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
asked
SQL Statement from DML Trigger
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?
