Transaction context in use by another session.

[Ramana]

Hi,

I tried to Insert a new record into Table "X" On Server"A".
I have a Insert trigger written on Table "X" ON Server "A"
which selectes new records inserted into table "X" and
Inserts these new records into Table "Y" ON Server "B".
Server "B" is having an Job running to perform some select
statements from Table "B" and inserting into other tables
ON Server "B".

When I tried to Insert a new record into tbale "X" I am
Getting the following error.

Server: Msg 3910, Level 16, State 1, Procedure TgmclShip,
Line 9
Transaction context in use by another session.

I was going through microsoft article (Q279857) and it
says it an BUG in SQL server 7.0 and 2000.

To work around this problem it recommended

1)Do not enlist the Data Pump in a transaction.
2)Transfer data by using Transact-SQL scripts rather than
DTS. Moving data without transformation is much faster
with a query.
3)Place the source and destination databases on different
servers.

But I am not doing this Through DTS, it is an Transact Sql
Script.Source and destination databases are on two
different servers.

RM

[Umachandar Jayachandran]

Do you have SET XACT_ABORT ON enabled in the SP? Apart from this, there
are several settings that are required for distributed transactions to work.
BOL has a several topics that document these requirements.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )