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)
 Trace Flags

Author  Topic 

scottpt
Posting Yak Master

186 Posts

Posted - 2003-11-19 : 16:11:10
Does any one have a list of all available trace flags?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-11-19 : 16:16:39
http://www.databasejournal.com/features/mssql/article.php/1442191
http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx

Just google trace flags in SQL Server. I got lots of results returned and a lot of them show the undocumented ones.

Tara
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-05 : 22:27:35
http://www.sqlservercentral.com/columnists/RDyess/traceflags_printversion.asp

That's the most complete list I know of. Don't use most of them.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-12-07 : 21:04:45
quote:
Originally posted by scottpt

Does any one have a list of all available trace flags?



Be careful - there are some undoc'd TFs that will instantly crash your server if you don't turn them on at server startup. You're playing with fire if you start turning on random TFs.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page
   

- Advertisement -