magritton
9/15/2015 - 3:49 PM

Checks the trace status and then turns the trace on. The -1 means that the trace was set globally. This was done to track deadlocks.

Checks the trace status and then turns the trace on. The -1 means that the trace was set globally. This was done to track deadlocks.

SQL DBCC Traceon.sql
content_copyfile_download
DBCC TRACESTATUS (1204, 1222);

DBCC TRACEON (1204, 1222)

DBCC TRACEON (1222, -1)