question

Paresh Prajapati avatar image
Paresh Prajapati asked

SQL Statement from DML Trigger

How can i know which sql statement fired through trigger for select, insert, update and delete on table?

Thnaks, Paresh Prajapati http:\paresh-sqldba.blogspot.com

sql-server-2008sql-server-2005t-sql
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TG avatar image TG commented ·
First, there is no trigger for select. Do you actually want to capture an nvarchar value representing whatever statement caused the trigger to fire? Or do you simply want to know things like which (I,U,D action) was fired and what the before/after values are?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.