Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

SQL Server Trace Flags Expand / Collapse
Author
Message
Posted Wednesday, June 2, 2010 8:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 PM
Points: 265, Visits: 846
Comments posted to this topic are about the item SQL Server Trace Flags
Post #931790
Posted Wednesday, June 2, 2010 10:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 3:29 PM
Points: 73, Visits: 520
Brillient!!!

Have been looking for a Central trace flag list for ages - and now it exists on SSC - nice one!


--Chris Hamam

Life's a beach, then you DIE (Do It Eternally)
Post #931818
Posted Wednesday, June 2, 2010 10:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 PM
Points: 265, Visits: 846
Be posted, I'll add a few then and now as I find and test them.
Pleasured while sharing; it will be a privilege if you can share comments for something’s missing or wrong.
Post #931823
Posted Thursday, June 3, 2010 12:37 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 5:19 AM
Points: 646, Visits: 1,854
Thanks...looks like a very comprehensive list.

To avoid any misunderstanding, it would be good if you acknowledged your sources, when compiling your master list.

Regards,

David.
Post #931861
Posted Thursday, June 3, 2010 12:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 PM
Points: 265, Visits: 846
Will try to include that, though I'm not sure how many I can recall some of them have been taken offline.
Post #931866
Posted Thursday, June 3, 2010 1:04 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 5:19 AM
Points: 646, Visits: 1,854
This ssc article contains a similar - but much shorter - list and refers to the Transact SQL Reference Guide - but the associated site is, indeed, offline.

Your list has all these plus much more, which for me makes it much more valuable, but if you don't attempt to quote your sources, there is the risk that it may be misconstrued.

Thanks,

David.
Post #931869
Posted Thursday, June 3, 2010 1:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 PM
Points: 265, Visits: 846
Every flag that I add/edit in my list now on will sure carry sources along with.
Promise.
Post #931870
Posted Thursday, June 3, 2010 2:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 31, 2011 11:45 PM
Points: 5, Visits: 16
How about this one?

DBCC TRACEON(8765)

This allows the use of variable length data, from ODBC driver.

http://bugs.mysql.com/bug.php?id=46857

So there are more undocumented ones?
How can we get a complete list of all of them?


Post #931912
Posted Thursday, June 3, 2010 3:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 PM
Points: 265, Visits: 846
Ms Support keeps on sharing a few on forums on case to case basis, other wise you may find them in personal blogs. And thanks to contributions from friends like you I'll keep adding ti my list & share them as soon as I have some weitage.
Post #931929
Posted Thursday, June 3, 2010 4:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 2, 2014 10:06 AM
Points: 49, Visits: 540
This is great, thanks!
Post #931988
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse