Unable to trace the Truncate table event

• Ashok kumar-317306

  SSC Journeyman

  Points: 78

  More actions

  February 8, 2007 at 12:28 am

  #194233

  Hi,

  Iam able to trace the events like object created/modified/dropped but not table truncation. Please help me how to trace the event whenever the table gets truncated.

  Thanks,

  Ashok

• bledu

  SSChampion

  Points: 12335

  More actions

  February 9, 2007 at 7:06 am

  #688811

  Truncate Table is essentially T-SQL so you could conceptually use the following T-SQL event classes

  SQL:BatchStarting

  SQL:StmtCompleted

  SQL:StmtStarting

  You then probably do a filter on the TextData column like %Truncate%

  Hope that helps

  ---

  Everything you can imagine is real.