SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Get SQL that caused an update
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cooper2989
Starting Member

2 Posts

Posted - 07/17/2014 :  05:46:33  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000