Auditing

• matthewsp

  SSC Veteran

  Points: 297

  More actions

  December 17, 2004 at 4:59 am

  #84392

  I wish to be able to Audit any Object events including Updating an object structure, Inserting or Deleting it.  This is to discover when and who has been adding modifiying or dropping Tables, Triggers and SPs.  Can anyone advise how to best approach this problem?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  December 17, 2004 at 9:38 am

  #534340

  Off the top of my head, there's SQL Server's C2 auditing, SQL profiler tracing, and products for purchase like Lumigent's Entegra. 

  Greg

   

   

  Greg