3988

Product Name

Event ID

3988

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

XACT_UNSUPPORT_PARALLEL_TRAN2

Message Text

New transaction is not allowed because there are other threads running in the session.

This error occurs when you execute a distributed query that joins multiple tables hosted by

remote instances of SQL Server while the

session setting is. An error message

similar to the following is reported to the user:

Msg 3988, Level 16, State 1, Line #

New transaction is not allowed because there are other threads running in the session.

There are some design limitations in the way SQL Server handles distributed queries (DQs)

when the following conditions are true:

joins multiple tables of one remote SQL Server data source.

The session that is issuing the query is not enlisted in a distributed transaction.

In this situation, an attempt to run the query may raise either of the two errors that are

mentioned in the

section.

ﾉ

Expand table

XACT_ABORT