Audit Logging

• cpack

  Ten Centuries

  Points: 1299

  More actions

  January 11, 2006 at 8:08 am

  #93160

  Is there a registry key, or a table in the mater database that contains information on Audit logging? I am trying to automate a process, and want to query the state of audit logging (None, Failure, Success, All) without using EM. Thanks.

  Edit: This is SQL 2000 specific.

   

  Cody Pack
  MCSE Windows 2000
  MCDBA SQL Server 2000

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  January 11, 2006 at 8:55 am

  #614089

  Cody,

  look at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\'Auditlevel'

  Markus

  [font="Verdana"]Markus Bohse[/font]

• cpack

  Ten Centuries

  Points: 1299

  More actions

  January 11, 2006 at 9:03 am

  #614091

  Great, Thanks. I was looking in HKLM\SYSTEM not HKLM\SOFTWARE.

  Cody Pack
  MCSE Windows 2000
  MCDBA SQL Server 2000