How to use the trace flag 1204

[manohars]

Our application uses a 3-tier architecture with flash as front end, dotnet as middle tier and sql server as

back end. In few of the transactions, deadlocks occur. I want to use the trace flag 1204 or 1205 to identify

which procedure causes the deadlockm exactly. I don't want to put the trace flag while starting SQL Server,

but only at the time of transaction. Can anyone suggest?

Thanks in Advance,
Manohar

 

[JamesLean]

Look up DBCC TRACEON in BOL.

--James

 

[manohars]

Trace flag 1204 or 1205 will give information about the deadlocks. When and Where we can see its output, if a deadlock occurs.

Thanks,
Manohar