Trace Flags

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  July 1, 2011 at 3:16 pm

  #1347361

  Thank you Koen, Kiara and Mark , I appreciate your help

  Have a nice day,

  Iulian

• Peter Trast

  SSCarpal Tunnel

  Points: 4392

  More actions

  July 1, 2011 at 9:01 pm

  #1347387

  Took a guess based on other objects having scopes at the session and global level like temp tables and variables, and got it right.

  Very cool. Nice question.

  Peter Trast
  Microsoft Certified ...(insert many literal strings here)
  Microsoft Design Architect with Alexander Open Systems

• Paul White

  SSC Guru

  Points: 150467

  More actions

  July 4, 2011 at 5:26 am

  #1347768

  tnk7200 (6/30/2011)

  ---

  I don't think there's any confusion about today question. Thanks Steve.

  Uh oh!

  Trace flags can also have statement scope, using the (undocumented) OPTION (QUERYTRACEON xxxx) syntax. Just saying.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi