Simple question on Trace flags.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Simple question on Trace flags.

Author

Topic

Hariarul
Posting Yak Master

160 Posts

Posted - 2007-09-20 : 00:50:47

Hi all,

I have a very simple question on the trace flags.

After setting the trace on like below,

dbcc traceon (1204, 3605, -1)
go
dbcc tracestatus(-1)
go

Where should I go to see what caused the deadlock ? Actually my question is what does the trace do when it is ON and where it records events for us to view ?

Any help would be appreciated.

Thanks,

Hariarul

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-09-20 : 02:07:40

Hi,

From MSDN--
Trace Flag 1204 and Trace Flag 1222
When deadlocks occur, trace flag 1204 and trace flag 1222 return information that is captured in the SQL Server 2005 error log.

for more info see the Link
http://msdn2.microsoft.com/en-us/library/ms178104.aspx

Hariarul
Posting Yak Master

160 Posts

Posted - 2007-09-20 : 02:49:42

Thanks PeterNeo

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources