Any way to capture TRUNCATE TABLE Event

Last post 09-08-2008, 2:43 AM by baddy. 0 replies.
Sort Posts: Previous Next
  •  09-08-2008, 2:43 AM Post number 69448

    • baddy is not online. Last active: 10-30-2008, 5:49 AM baddy
    • Top 25 Contributor
    • Joined on 04-07-2008
    • India
    • Blue Gene

    Any way to capture TRUNCATE TABLE Event

    Hi Experts - Is there any way to capture TRUNCATE Table event from DML
    or DDL trigger or a from any other SP or else...

    I want to capture this event whenever any truncate command executed on
    my DB vis Programming or from Query analized, just to know that on which
    table truncate command is executed...Actually for number of tables I'm
    maintaining history tables and whenever any truncate table cmd excuted
    on any table I want to truncate the correspond history table
    Any suggestion please?


    Thanks,
    Baddy
View as RSS news feed in XML