How to monitor DDL commands

• day-476284

  SSCommitted

  Points: 1844

  More actions

  March 19, 2008 at 3:11 pm

  #71466

  Hi all,

  Is there any way to monitor DDl commands in SQL Server 2000 without applying third-parties?

  Thanks,

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 19, 2008 at 3:23 pm

  #791768

  You can monitor with Profiler. See "Event Classes" in BooksOnLine for lists of events that can be monitored.

  Greg

• SQLZ

  SSChampion

  Points: 12872

  More actions

  March 20, 2008 at 2:07 am

  #791873

  Or you could enable C2 auditing - but then you're auditing more than just ddl commands.

  Karl
  source control for SQL Server