Auditing DDL changes

• v03066

  SSC Enthusiast

  Points: 116

  More actions

  March 17, 2006 at 1:39 pm

  #152838

  Hi,

    I need to set up auditing at the server level to see who is changing the structures of tables to be reported to Auditors. How can I do this

  TIA

  Mo

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  March 17, 2006 at 7:11 pm

  #627465

  hi,

   

  U can setup profilor or u can  also enable C2 auditing level from sp_configure.

   

  HTH

  from

  Killer