Unable to trace the Truncate table event

  • Ashok kumar-317306

    Valued Member

    Points: 68

    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

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply