I need to get detailed info on whatever may be causing deadlocks. i have seen many different iterations of the TRACEON statement;
DBCC TRACEON(-1, 1204, 3605)
DBCC TRACEON (3605,1204,-1)
which is it? and its corresponding TRACEOFF?
also, i can do this w/out restarting sql, correct?