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 2000 Forums
 SQL Server Administration (2000)
 TRACEON/TRACEOFF

Author  Topic 

ssunny
Posting Yak Master

133 Posts

Posted - 2008-12-10 : 14:12:35
Hi There,

I got following messages in sql log today.

DBCC TRACEON 1717, server process ID (SPID) 220.
DBCC TRACEOFF 1717, server process ID (SPID) 220.

I googled it and found out that these are warning messages. Can somebody shed some light on this please? And where can I find complete list of trace flags?

Thanks.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-10 : 18:31:16
quote:
Originally posted by ssunny

Hi There,

where can I find complete list of trace flags?

Thanks.




Booksonline.
Go to Top of Page

ssunny
Posting Yak Master

133 Posts

Posted - 2008-12-11 : 10:31:41
quote:
Originally posted by sodeep

quote:
Originally posted by ssunny

Hi There,

where can I find complete list of trace flags?

Thanks.




Booksonline.


Thanks Sodeep. Booksonline has only four trace flags specified. But I was under the impression that there should be more than four.
Anyway thanks again.

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-11 : 11:01:42
Here is what I got by searching.
http://www.sqlservercentral.com/articles/Monitoring/traceflags/737/
Go to Top of Page

ssunny
Posting Yak Master

133 Posts

Posted - 2008-12-11 : 11:20:01
quote:
Originally posted by sodeep

Here is what I got by searching.
http://www.sqlservercentral.com/articles/Monitoring/traceflags/737/


Wow, thank you sir.
Go to Top of Page
   

- Advertisement -