DBCC TRACEON (1024,1222)
Turn off dead lock trace flag
DBCC TRACEOFF (1024,1222)
Enable Trace Flag 1024, 1222 to detect deadlocks in msssql server
How to enable trace flag 1024, 1222 to log the deadlock sql's to the error log.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment