Hi all,
I would like to find information about the session in which INSERT/UPDATE/DELETE triggers are executed.

To be more specific, can a trigger fire in response to an INSERT/UPDATE/DELETE event that appended in another session?

In other words, can the trigger session be different from that in which the trigger was generated?

I cannot find coherent information on the Internet and the problem is related to my other question:
http://social.msdn.microsoft.com/Forums/windowsazure/en-US/12193526-ba71-4087-94eb-d43ba65b5813/passing-parameters-to-a-trigger-in-a-multiuser-environmet#bf8e635e-d6d1-493e-8030-58029deed6fe

Thanks in advance for any help