Trace Update, Insert and Delete statements in a Database

• Mathew M.Varghese

  SSCommitted

  Points: 1929

  More actions

  February 7, 2006 at 7:32 am

  #111469

   

  This is a continon of the forum Topic

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=179673#bm180501

   

  When I create the trigger and run the application and make some update and insert, Instead of sql commands, it is showing sp_prepexec;1 and sp_executesql;1.

   

  I need the Each insert and delete command should store my logtable instead of sp_prepexec;1 and sp_executesql;1..

   

  Please help me if any other way to trace all insert, update and delete statements in a Database.

   

• Mathew M.Varghese

  SSCommitted

  Points: 1929

  More actions

  February 7, 2006 at 11:57 am

  #619365

  Dear All,

   

  Pls provide any ways to trace Update,Insert and Delete of a specific tables.

   

  Mathew