deadlock in the error log – SQL 2000 trace flags? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

deadlock in the error log – SQL 2000 trace flags?

Are the trace flags you need to run to post full deadlock info in the error log the same in SQL Server 2000 as they used to be in SQL Server 6.5? Books Online is.. somewhat lacking on the topic of Trace Flags. TIA Tom Pullen
DBA, Oxfam GB
May refer to this link http://www.databasejournal.com/features/mssql/article.php/1442191]. HTH _________
Satya SKJ

Thanks Satya, just what I needed. Tom Pullen
DBA, Oxfam GB
Oh yes.. for anyone interested.. the answer is:- -T1204
-T1205 (optional, more detailed info)
-T3605. Tom Pullen
DBA, Oxfam GB
Yup, only T1204 is specified in BOL but not others. _________
Satya SKJ

]]>