sql server (alternate): Fetch Query that triggered the TRIGGER -- sql server (alternate)

Fetch Query that triggered the TRIGGER

Anubhav
12/25/2006 11:13:19 PM

sql server (alternate):

Hello

The problem is need to find out the querry that has updated or inserted
into the table and in turn 'Triggered the Trigger'. I have the user
name, the machine name, Application name, but not the query. The update
is not desired and the application is doing it but the application
being so large we are unable to pin-point the code which is doing the
dammage.

Pls help!

Regards
Anubhav

Re: Fetch Query that triggered the TRIGGER

Erland Sommarskog
12/26/2006 12:00:00 AM

Anubhav (anbansal@gmail.com) writes:
[quoted text, click to view]

If the UPDATE is coming directly from a client, you can use

dbcc inputbuffer(@@spid) with tableresults

but if the error is in a stored procedure, you will not see the UPDATE
statement, only the call submitted by the client.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at