Paul Hartland
paul.hartland at googlemail.com
Wed Oct 15 02:50:02 CDT 2008
To all, We have started getting a couple of deadlocking issues every now and again, I have read that you can turn on a trace using DBCC TRACEON (1204) Can anyone tell me, where this command will put the results in a case of a deadlock being raised. Or has anyone any better ideas, of how I can find out the queries/views/SP's that are causing the deadlocks please. I have told each of our staff to report to me immediately if they get a deadlock issue, so then I want to look at a report or log to attempt to find out what is going on. Thanks in advance for any help on this. -- Paul Hartland paul.hartland at googlemail.com