How would you turn on C2-Level auditing?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 735590

  More actions

  October 10, 2007 at 5:29 pm

  #62857

  Comments posted to this topic are about the item How would you turn on C2-Level auditing?

• isadler

  Newbie

  Points: 7

  More actions

  June 9, 2008 at 11:19 am

  #826219

  Is the following incorrect?

  You can enable C2 auditing with the SQL Query Analyzer. Sysadmin privilege is required to enable or disable this option.

  1 In the SQL Query Analyzer, enable the show advanced options configuration option using the following command:

  USE master EXEC sp_configure 'show advanced option', '1' RECONFIGURE

  2 To enable the feature, set c2 audit mode to 1 using the following command:

  sp_configure 'c2 audit mode', 1 go

  3 To disable the feature, set c2 audit mode to 0:

  sp_configure 'c2 audit mode', 0 go