I am having deadlock issues and have been reading articals on ee as to how to trace my deadlocks.
I have seen the command DBCC TRACEON (3605,1204,-1), can anyone tell me what I do with this? I assume I paste into query analyser but how do I or indeed is there an output to reveiw?
Also do I need to switch it off again? in short and as only one question can someone tell me how to use this command?