Viewing post 1 (of 1 total)
You could also try enabling the SQL Server trace flag so that all deadlocks are recorded in the SQL log. This won't require a reboot either.
dbcc traceon (1204, 3605, -1)
go
dbcc tracestatus(-1)
May 9, 2007 at 12:56 pm
#705360