Trace flag for monitoring the deadlock in sql server 2000

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

1204 & 1222.

Trace Flags (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188396.aspx

ps. One Orange Chip Points: 29423 More actions · Answer 2

Dev (11/28/2011)
1204 & 1222.
Trace Flags (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms188396.aspx

1222 is for 2005 and above.

1204 will work in 2000.

Pradeep Singh

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 3

Dev (11/28/2011)
1204 & 1222.
Trace Flags (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms188396.aspx

I wouldn't use both. I'd just use 1222 (which won't work in this case). Too messy in the error log otherwise.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt