InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:12:58 GMT20http://www.sqlservercentral.com/Forums/Topic544612-65-1.aspxVery helpful information....I always read that use about trace flag but didn't find info about how to check it's output.Tue, 14 Feb 2012 08:22:42 GMTlogicinside22http://www.sqlservercentral.com/Forums/Topic544612-65-1.aspxThanks for your help guys - I did finally find the cause of my problem:http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=42001&enterthread=yBasically this is the output you get when a query use a parallel QEP. Hopefully that info will save someone else the grief and hours this has taken me to get to the bottom of!Mon, 04 Aug 2008 11:35:41 GMTKitKaterinahttp://www.sqlservercentral.com/Forums/Topic544612-65-1.aspxHi - Thank you for your reply - I have included T3605 - I am getting output to the SQL log - but not what I have seen in the past or what I expected to see! Any other ideas?Mon, 04 Aug 2008 04:59:10 GMTKitKaterinahttp://www.sqlservercentral.com/Forums/Topic544612-65-1.aspx1204 and 1205 write deadlock graphs and associated info into the SQL error log. If you aren't having deadlocks, you won't see anything written. I wouldn't usually suggest using both. 1204 is usually good enough for identifying deadlocks. 1205 can get very, very verbose.What were you expecting them to be writing into the error log?Thu, 31 Jul 2008 13:17:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic544612-65-1.aspxThe 1204 and 1205 only collect information about deadlocks but to write the information to the SQL Server log file, you need to include -T3605Thu, 31 Jul 2008 12:09:55 GMTCarl Federlhttp://www.sqlservercentral.com/Forums/Topic544612-65-1.aspxHi AllI'm a long time lurker - this is my first post, so hello and I hope you can help! :DI have just enabled trace flags 1204 and 1205 on a new server, which is at SQL Server 2000 SP4. Funny thing is I am not seeing the output which I expected to see in the event log, I'm not seeing KEY, TAB or PAG references, and also nothing from the buffer. Has anyone else experienced anything similar? Has anyone got any ideas how to get all the detail back in the output from these trace flags?Thu, 31 Jul 2008 11:56:52 GMTKitKaterina