Learn more about SQL Server tools

   
   


















































SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

I had 4 different MS Sql 2008 servers, which had the data's of same application type. I need to merge the database from all 4 system to one
I had 4 different MS Sql 2008 servers, which had the data's of same application type. I need to merge the database from all 4 system to one. Kindly suggest me how to merge the database.

asked 2/5/2015 4:25:10 AM
by Anbazhagan M
2 answers

is it mandatory remove witness server while do patching on db mirroring
is it mandatory remove witness server while do patching on db mirroring if yes reasons tell me

asked 2/5/2015 2:33:17 AM
by venkata
2 answers

Moving a 2 node Windows Server 2012 / SQL Server 2012 cluster from Location A to Location B without any downtime - Location A and B are networked, however there is no physical heartbeat network available between the two physical sites
Can Windows Server 2012 / SQL Server 2012 cluster failover, with the cluster heartbeat network disconnected   We are looking to move a 2 node Windows 2012 /SQL Server 2012 cluster nodes from Location A to Location B without any downtime.  We h

asked 1/29/2015 5:05:04 PM
by Ina Jafri
0 answers

Tracking all DML operations?
Hi,   I am database contains N no of the table and i would like to Trace or Track all DML operation performed on the Tables.Please help me?

asked 1/29/2015 6:38:55 AM
by Viswanath
1 answers

Import excel into SQL
there is no duplicate in the excel sheet, when I imported the excel into SQL, is there a lot of dupicate in the table

asked 1/28/2015 7:27:07 AM
by Linda van Schalkwyk
0 answers

Executing Stored procs Parallely
/*                Actually I have doubt                        &n

asked 1/28/2015 2:33:33 AM
by Farid Shaik
0 answers

Too many db queries
My host is kicking me to a default wp-install page rather than my home page becasue, they say, that I am exceeding 75,000 db queries per hour. I can't imagine that my traffic is generating such a load on the db/server, so I am confused. Is there a way to

asked 1/27/2015 5:19:34 PM
by A
1 answers

SQL Server Agent job failed
In SQL Server 2012 running a SQL Agent job I received this error message: The definition of object 'usp_CCAR14_Load' has changed since it was compiled. [SQLSTATE 42000] (Error 2801).  The step failed.,04:43:46,16,2801,,,,0 Is it true that after mak

asked 1/27/2015 11:23:10 AM
by Tim
2 answers

SSRS report How to show all products by rank and then show in same report how many of each item a particular customer purchased based on parameter
I have an SSRS report that will allow our sales reps to choose a customer and then the report will show in the top section the customer information, a sales summary and in the bottom it will list our products ranked by the top sellers overall by category

asked 1/27/2015 10:38:11 AM
by Angela Eberle
0 answers

E-Mail Alert from SQL Server 2012
I have written an Stored Prodcedure and it will return the count of gender (like 10 Female, 5 Male) from table. These details should be send to the SQL Administrator in the mail format (not HTML text) daily 1PM IST. I am using SQL Server 2012 Enterprise E

asked 1/27/2015 2:04:38 AM
by Siva
2 answers

To create a share folder for database log shipping
  Hello,   can you please tell me how can we create a share folder for database log shipping in sql server .

asked 1/26/2015 8:45:22 AM
by ganesh
2 answers

I want to Insert results of a Stored Procedure into a Temporary Table, if The procedure that i call refers temp tables created in the current connection. even I donít know the schema of Return table. e.g.( Create procedure [dbo].[procA] as select * from #countries) once I execute the procedure it will display the rows of TableA. I want to store those rows into a temp table for further analysis. I tried many approaches but failed. I tried : se
I want to Insert results of a Stored Procedure into a Temporary Table, if The procedure that i call refers temp tables created in the current connection. even I don’t know the schema of Return table. e.g.( Create procedure [dbo].[procA] as  sel

asked 1/24/2015 6:31:48 AM
by ross
0 answers

Creation of LocalDB instance "LocalDB_1" with version 11.0 failed
Installed "SQL Server 2012 Express LocalDB" successfully.  Output of SqlLocalDb info v11.0. When I tried to create instance LocalDB_1 I'm getting this error: Creation of LocalDB instance "LocalDB_1" with version 11.0 failed because of the following e

asked 1/23/2015 7:09:41 PM
by Eugene
0 answers

Why would I choose UNION versus PIVOT to "de-flatten" a non-normalized table
We have a table with 500+ columns.  The data is non-normalized, i.e. there are four groups of fields for for "people", followed by data that applies to all people in the row (a "household"). For ad-hoc queries, and because I wanted to index columns

asked 1/23/2015 9:48:43 AM
by Wayne
1 answers

ssrs cell 3 color grading like Excel
Hi,   I have a column in ssrs report with the name "Ratio" in "Main" dataset and values from 0-100..i need graded background color from transperent-orange-red(starts with transperent to lite to thick orange to lite red to thick red) Could you plea

asked 1/22/2015 7:06:16 AM
by sasikirane
0 answers

MSSQL 2012 renaming a database
What are the pitfalls in renaming a database?

asked 1/19/2015 2:19:46 PM
by katty davis
0 answers

Naming a Default constraint during table creation
Hello, I want to name a default constraint during table creation like we do for primary key or foreign key columns. CREATE TABLE tblAdminLogin([Id]  INT IDENTITY,[Name]  VARCHAR(20) DEFAULT 'NOT KNOWN',[Password] VARCH

asked 1/19/2015 5:50:59 AM
by kamakhya
1 answers

User pack
How many user pack for MS Sql server 2012 express .

asked 1/15/2015 7:29:34 AM
by Kamal Ansari
1 answers

SQL Server Update Statistics
Hi Guys,   After reindexing the Database, is it necessary to update Statistics for the Database ? We have scheduled the jobs for the weekends for some time now on the PROD but still we are getting performance issues starting from mid week. Please

asked 1/13/2015 11:56:12 PM
by Subhamoy Ghosh
1 answers

triggers
  how to join a two tables in trigger in sql server

asked 1/12/2015 5:49:21 AM
by tamil
2 answers


 
Sponsor Information