Trace Flag

  • Chandra Sekhara Vyas Dhara


    Points: 10207

    Comments posted to this topic are about the item Trace Flag

  • Hany Helmy


    Points: 13321

    Nice question & a good feature will think to get use of it.

  • Koen Verbeeck

    SSC Guru

    Points: 258941

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • RKaram


    Points: 1518

    Very nice question!:-)



  • Toreador


    Points: 11231

    I'm never very good at these historical questions 🙁

  • TomThomson

    SSC Guru

    Points: 104772

    Nice question. At one point I would have found a means of logging full and incremental backups but not log backups useful, but that feature has never been provided.


  • ksatpute123

    Hall of Fame

    Points: 3325

    This trace flag has existed for some time but was documented only in SQL 2008.

    It works for SQL 2008, 2005 and 2000 SP4 (not tested) update.

    Here is the source with more clarification.

  • twin.devil


    Points: 22208

    Nice question. Thanks for sharing

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

  • david.gugg


    Points: 5624

    Good question, learned something new.

    Thank you

    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"][/url]/[/font]

  • Ed Wagner

    SSC Guru

    Points: 286958

    A very good question - thanks. I learned something new and think I'm going to use it.

  • Raghavendra Mudugal


    Points: 10658

    Ed Wagner (10/30/2014)

    A very good question - thanks. I learned something new and think I'm going to use it.

    +1 (except the "using" part)

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Shawn Melton


    Points: 24675

    This trace flag is still available in current versions, and will probably never go away. This is a part of my checklist for installations and is always enabled.

    I would like to see this become an option that we can enable with sp_configure or similar. Just like successful logins is handled.

    Shawn Melton
    Twitter: @wsmelton
    Github: wsmelton

  • pmadhavapeddi22


    Points: 5306

    learnt something new today

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply