Topic: SQL SERVER 2008 sp4 Transaction context in use by another session
All kind time!
Is such :
2 servers And and to each other moreover and loopback both (physically by different machines). There is an application which adds at first in the table of basis allocated on server A On the table the trigger (after update insert) which adds on a condition in the table on the server B. [b] On the server, on this table is registered as the trigger which of application updates the table hangs And and something Would draw out for something from the table on the server further in the trigger (normal select). here happens such that at some users (not at everything, but occasionally happens), at attempt to update the table of the server the table on the server And (on which the trigger writes that to the table And it is selected fat above) hangs up application and throws out an error Transaction context in use by another session
Prompt , what in such situations it is possible to try to make? About distributed transactions on loopback servers heard, but salt that the error arises no means always.