SQL CODE BANK
Search
Wednesday, July 27, 2011
Start a trace on deadlocks and write it to sqllog
DBCC TRACEON (-1, 1204, 3605)
This means as follows:
(-1 all connections,
1204 deadlock details,
3605 write output of trace flag to SQL error log).
DBCC TRACEOFF(-1, 1204, 3605) turns it off).
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment