See what caused the start of SQL?

Question

I'm just wondering if it is possible to see which stored procedure or SQL statement was made to trigger the trigger somewhere in the trigger.

I have a really strange error when the field has changed, and I can’t understand why this is happening. I have a trigger that registers that the data has been changed, but it would be great if I could also register which sql statement caused the field to change.

Is it possible?

Answer 1

SQL- . , , , : http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/c87621996c73012b

... : " SP: .

SP: : http://msdn.microsoft.com/en-us/library/ms188675.aspx

Answer 2

, OBJECT_NAME (@@Procid) . @@SPID .