Monitoring Truncate Table

• Pouliot Philippe

  SSCommitted

  Points: 1912

  More actions

  April 19, 2011 at 9:03 am

  #145494

  Hi everyone, How can Monitoring the command "Truncate table". ? Log,Trigger ?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  April 19, 2011 at 10:22 am

  #1313502

  You can read the Default Trace[/url] to get that information.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Pouliot Philippe

  SSCommitted

  Points: 1912

  More actions

  April 19, 2011 at 11:55 am

  #1313560

  Nice tip, but i don't see anywhere The eventID for the truncate table operation