How do I view trace flag output

microsoft.public.sqlserver.server

20 Nov 2007 5:17 PM

Chris

I am trying to troubleshoot a frequent deadlock and I found an article that
says to run the following command:
DBCC TRACEON(3605, 1204)
I did this, but where does the trace output go?

Chris

20 Nov 2007 5:47 PM

Russell Fields

Chris, This information is put in your SQL Server's error log. - RLF

Show quote

"Chris" <f***@email.com> wrote in message
news:835BA2B0-A082-4775-9A68-B0DB65B7AA3C@microsoft.com...
>I am trying to troubleshoot a frequent deadlock and I found an article that
>says to run the following command:
> DBCC TRACEON(3605, 1204)
> I did this, but where does the trace output go?
>
> Chris