I have deadlock occurs in MS SQL 2008.
I look at the following instruction
and turn on trace by issuing command
DBCC TRACEON (1204, -1)
DBCC TRACEON (1222, -1)
Where to see the Trace Flag 1222 Output and Trace Flag 1204 Output.
I open the MS SQL log, i don't any deadlock info.
I want to see the output like the link above listed. Where to get that. Can you tell me the steps to see it