Have you tried by executing the install script (instawdb.sql)...

Script for AdventureWorks OLTP should be located in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP

You'll have to use CTE

DECLARE @InitialNumber INT

DECLARE @OutputNumber INT

SET @InitialNumber = 9

SET @OutputNumber = ( CASE WHEN @InitialNumber > 0 THEN -@InitialNumber ELSE @InitialNumber END )

SELECT @InitialNumber AS Initial, @OutputNumber AS Final

Works like a...

Check sys.server_principals

I don't know how we can directly execute a script within another script?

But here is, one of the ways which i used to execute a list of files from...

Be sure that the Total is unique for each location, otherwise you'll get into trouble..

Check here by adding one row as...

INSERT INTO @DerivedTable

SELECT 3, 931, 910

You can use the RESTORE HEADERONLY statement to know exactly what kind of backup file is it...Check BackupType output column

RESTORE HEADERONLY FROM DISK = N'C:\DatabaseBackups\YourBackupFile.bak'

DECLARE @FileName varchar(50),

@bcpCommand varchar(2100),

@Query varchar(2000)

SET @FileName = 't:\temp\test.txt'

SET @Query = 'bcp "Select...

little better....

SELECT TOP 1 @tmp = Value FROM Table ORDER BY NewID()

May be you can try this one......

SELECT T1.SalesPersonID, COUNT( * ) AS [Total Sales], T2.Date AS [Date Reached 100 Sales]

FROM Sales T1

LEFT JOIN ( SELECT SalesPersonsID, [Date], ROW_NUMBER()...

SELECT * FROM MyTable ORDER BY NEWID()

I guess, DTS or SSIS would possibly be the best solutions to the scenario...

This could be any of the following

1. The required network protocols are not enabled..

2. Remote Connections disabled

3. Windows firewall may be blocking the connection...

I guess, this can surely will improve the performance as it uses the a single update to accomplish the task....

DECLARE @LastNumber INT

SET @LastNumber = 25

IF ( OBJECT_ID( 'tempdb..#tmpProducts' ) IS...

You need to change your sql server's authentication mode to mixed mode.....

Go to Server Properties > Security ...Change the authentication mode to SQL Server & Windows...