Post reply

Trace for DELETE operations

  • October 1, 2004 at 1:02 pm

    #86622

    Is there a way to record/log when a DELETE transaction takes place?  I quickly went through Profiler, but can't determine how to configure it to record only DELETE.

    Thanks,

    Dave

  • October 1, 2004 at 1:36 pm

    #525085

    I can think of two solutions.

    1) Use profiler to trap the SQL.  Save the output to a table and use a select statement similar to

    SELECT textdata from <<tablename>> WHERE textdata like '%DELETE%'

    2) Add an after_delete trigger to the table(s) you want to monitor and write the information out to a audit file.

     

     

     

  • October 1, 2004 at 7:30 pm

    #525097

    You cannot trap just delete activity from profiler. If you are planning to run this long term I would suggest a tool like entegra from Lumigent that won't have the impact of running profiler or a server side trace 24X7.

    Wes

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

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