|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How do I view trace flag output
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 Chris, This information is put in your SQL Server's error log. - RLF
Show quoteHide 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  
Other interesting topics
Snapshot size
SQL Server Transaction Log growing SQL Server 2005: log shipping need urgent help ms sql cluster: should i and how to place tempdb on local drive Why sql server always choose index scan instead of index seek for my query? I dont see any hostname in sysprocesses BCP import large text file to sql tables SQL 2000 : space available is zero System table with max and min values for all SQL data types |
|||||||||||||||||||||||
