How to find which query is executing

[indoaryaan]

I have nText and DateTime columns in a table. A stored procedure updates the nText col for X number of users. The stored procedure does NOT query the DateTime column. But for few users, only some records(not all records), the DateTime column is being set to NULL. Clearly, a trigger is being fired sometime during the execution of the SP causing the NULL update on DateTime col. Is there a way, i can find which query(Trigger) is causing this during the execution of the main SP? Any help wpuld be appreciated. A sample script would be great....

Thanks....

 

[MDXer]

Try running SQL profiler. YOu can display the start and completion of all tsql statements as they execute.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck