Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Get SQL that caused an update

Author  Topic 

cooper2989
Starting Member

3 Posts

Posted - 2014-07-17 : 05:46:33
Okay this is a debug query, i have a table t_A with an after update trigger dumping into t_A_Audit from inserted and deleted for tracing a bug.

I am trying to get the SQL statement that caused the update on t_A in the trigger on t_A, and then write that into the t_A_Audit for traceability. the system is express edition 2008r2 so no nice profilers to help me.

Any help would be greatly appreciated :D
   

- Advertisement -