Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error 3910: Transaction context in use by another session

284 views
Skip to first unread message

MorganC02

unread,
Dec 10, 2001, 10:02:02 PM12/10/01
to
Does anyone know how to resolve the error listed in the
subject ? I'm receiving this error message in an sp that
uses a linked server and distributed transactions. The
code where it's failing is below. What's weird is that I
have two other sps using the same identical transaction
code but they have one insert to the linked server and
only the one update to the local server.

Thanks,
MorganC02

Begin Distributed Trans A

Insert LinkedServer.Database.dbo.table1 (col1, col2, col3)
Select col1, col2, col3 FROM #tmpTable1

Insert LinkedServer.Database.dbo.table2 (col1, col2, col3)
Select col1, col2, col3 FROM #tmpTable1

-- on local server
Update table3 SEt .... Where ....

If @errnum <> 0 then rollback tran A Else commit tran A.

Darren Green

unread,
Dec 11, 2001, 3:13:35 PM12/11/01
to
In article <026201c181f0$34e2fdb0$9ae62ecf@tkmsftngxa02>, MorganC02
<Morg...@Hotmail.com> writes

Bug-
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q279857

Fixed in SQL 7.0 SP3-
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;Q256649

--
Darren Green (SQL Server MVP)
http://www.sqldts.com

(Which version of SQL Server? What is the full error message?)


nono

unread,
Dec 12, 2001, 3:58:23 AM12/12/01
to
Hi,
I have the same problem.
I seen these articles. This bug has been resolved in SP3 sql7 but not in SP2
of SQL2000 !!!!
: (

Charlene Morgan

unread,
Dec 12, 2001, 9:37:48 AM12/12/01
to
I'm using SQL Server version 7.0. The full error message is Transaction context in use by another session. [SQL State 42000][Error 3910].

We may actually have some weird thing going on our server because this appears to be an intermittment problem. The code worked one day, stopped working one day, and is now working again. I didn't change any code. Grrr ...

One thing I did change was the Select that I was using to insert data into a table on a linked server. I changed from using a distributed join with local temp tables and tables on the linked server to saving the data I needed from the linked server in local temp tables and using all local temp tables to select data for my insert into a table on the linked server.

Thanks for the information.

Charlene

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Darren Green

unread,
Dec 13, 2001, 3:55:16 AM12/13/01
to

"nono" <az...@azaz.com> wrote in message news:ez9jBtugBHA.1816@tkmsftngp02...

> Hi,
> I have the same problem.
> I seen these articles. This bug has been resolved in SP3 sql7 but not in
SP2
> of SQL2000 !!!!
> : (
>
>

Try placing a call to Product Support Services (PSS). They might have some
more info...

0 new messages