Post reply

How to track delete/insert/update on a table via SQL Profiler 2005

  • October 21, 2008 at 4:56 am

    #383154

    How do I trace the SQL text applied to particular objects in a database. Specifically when records are deleted/inserted/updated. I read that it's only possible to do this via triggers, is that really the case ?

    I would have thought SQL Profiler could do this ... although I can't see how to set it up. Is my only option to create triggers to audit at this level. I'm using SQL2005

  • October 21, 2008 at 5:12 am

    #887518

    I belive you could fliter the ObjectID and Text like insert,delete,update

  • October 21, 2008 at 5:36 am

    #887527

    How do I do this in the Profiler ?

  • November 3, 2008 at 3:24 am

    #892909

    hi,

    you can start a new trace and select filter afetr an objectID and in text data like delete,insert ,update.

  • November 12, 2008 at 12:02 pm

    #897715

    Thanks for the replies I got it working.

Viewing 5 posts - 1 through 4 (of 4 total)

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