monitor
#monitor#8525

8525

Product Name Event ID 8525 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text Distributed transaction comple

Product Name

Event ID

8525

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

Message Text

Distributed transaction completed. Either enlist this session in a new transaction or the

NULL transaction.

The programming model for using the Distributed Transaction Coordinator with SQL Server

requires applications to explicitly enlist to and defect from a distributed transaction.

This error occurs when the following four conditions are met:

The application has enlisted into a distributed transaction.

The transaction has ended, either committed or rolled back, for any reason.

The user application has not explicitly defected from a distributed transaction or explicitly

enlisted into a new distributed transaction.

The application tries to do any transactional operation other than defecting from existing

distributed transaction or enlisting to a new distributed transaction, such as issuing a

query or starting a local transaction.

Error state 1 is used when the application performs an operation that creates local transactions,

and state 2 is used when application tries to enlist to a bound session.

Expand table