Topics
Started by
Posts
Last post
My boss has asked me to restore a database snapshot to a database other than the one that created t…
5 replies
The following code: create FUNCTION [dbo].[ufn_GenPK] ( @table varchar(100)) RETURNS int BEGIN …
6 replies
I have a stored procedure with a cursor that won't match the value I passed to it with the values i…
2 replies
I’ve restored a full and diff backup (in norecovery), but I can’t restore the trans log backup stor…
34 replies
Hi All.. I ran the query optimizer for a few larger sql statements. It recommended 3 indexes and a…
1 replies
How do I change the collation of the msdb and tempdb databases? Thanks
7 replies
I am trying to load data from a staging table into the target table. The target has some constraint…
3 replies
Hi everyone, I've taken the SQL found here to query autogrow status: http://beyondrelational.com/b…
5 replies
A client of mine happens to have SQL Server 2005 and they're not inclined to change that for the ti…
5 replies
I have the below code and it is returning error: Subquery returned more than 1 value. This is not p…
3 replies
Hi all, I will have to import text files into sqlserver. I will use OpenDataSource as described in …
3 replies
There is a table named "fathers" which has two columns:FatherName and DaughterAge Records are like …
13 replies
We are in the middle of creating a datawarehouse for a BI project. We are using linked servers and …
7 replies
We have SQL Server as a back-end for a manufacturing system. I need to use T-SQL to create a view o…
5 replies
Hello everyone, How can I pre-compile MS SQL Script to C++ code file, like what we did in Oracle wi…
2 replies
Viewing 15 topics - 4,471 through 4,485 (of 5,050 total)
You must be logged in to create new topics.