With the REPEATABLE READ transaction isolation level, I am seeing that the reader is blocking the writer but I am not sure why you are not seeing this behavior. Try...

In a Piecemeal Restore scenario, after the primary file group is restored, the database can be brought on-line with any secondary file groups that have not been restored being offline....

The results you are getting are documented in Books OnLine under the topics titled "int, bigint, smallint, and tinyint" and "Precision, Scale, and Length"

the result is weirdly out by a...

SSMS is not issuing a SQL command to perform the shutdown but instead, SSMS sending a windows command, so the security is based on the Window Login.

To demonstrate, do the...

Do you mean model 6410 ? (transposed the 1 and 4)

I use a Dell 6510 Dual Core 4Gb RAM, which has...

Try this:

;with EmployeeIds as

-- Assign Id sequentially using Rank

(SELECTempid

,RANK() OVER ( ORDER BY EmpId) as Id

FROM#tab

)

,AllIds as

-- For all of the Manager Ids, get the assigned Rank

(select#tab.empid

,#tab.mgrid

,EmployeeIds.Idas Id

,MgrIds.Idas...

First, validate the backup files by executing:

RESTORE VERIFYONLY FROM

DISK = 'D:\SQL_BACKUP\db_db1_20101028_1.bak',

DISK = 'D:\SQL_BACKUP\db_db1_20101028_2.bak',

DISK = 'D:\SQL_BACKUP\db_db1_20101028_3.bak',

DISK = 'D:\SQL_BACKUP\db_db1_20101028_4.bak'

BOL states "Verifies the backup but does not restore it, and checks to see...

Thanks for posting all the details and source as it made de-bugging and finding a solution much easier.

I found that adding to the trigger "SET CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS ON;" immediately after...

You would need an RTF to text converter routine to switch the data-types/ If one creates an RTF with some contents and then opens the file using Notepad, you...

It is a bug in SQL Server 2005 Managment Studio. The fix suggested by MS is to use the SQL Server 2008 Managment Studio.

MS SQL Server query plan information is documented in Books OnLine under "Database Engine", "Technical Reference", "Transact-SQL Reference", "System Views" and finally "Execution Related Dynamic Management Views and Functions". ...

QOD Part 2: Is January 31st, 2010 (the original date), the result of:

declare@StartDateTimedatetime;

SET@StartDateTime= CAST('2010-01-31T00:00:00.000' AS datetime)

SELECTDATEADD(MONTH, -3 , DATEADD(MONTH, 3, @StartDateTime))

You are running Sybase's bcp.exe instead of the MS SQL Server ! Here is the output you should get for MS's bcp.exe:

usage: D:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe {dbtable | query}...

Just to add to the assistance.

Please read Lynn Pettis article on calculating a person's age at http://www.sqlservercentral.com/articles/T-SQL/63351/

The correct calculation is

DATEDIFF(yy,Clients.DOB,@TodaysDate)

- case when @TodaysDate < dateadd(yy,datediff(yy,Clients.DOB,@TodaysDate),Clients.DOB)

then 1 else 0 end

When...

Windows:

Insure that "Maximize data throughput for network applications" is set instead of the default of "Maximize data throughput for file sharing"

Grant the SQL Server service account the following Windows privileges:

Perform...