Sql Error #8523, Severity 15

Sql Error Number:8523
Severity: 15

Description: PREPARE TRAN statement not allowed on MSDTC transaction.

Possibly related links:

Errors 8000 - 8999
Failed to get MSDTC PREPARE information: %hs. 8518. 20. MSDTC BEGIN TRANSACTION failed: %hs. ... PREPARE TRAN statement not allowed on MSDTC transaction. 8524. 16 ...

Errors 8000 - 8999
Failed to get MSDTC PREPARE information: %hs. 8518. 20. MSDTC BEGIN TRANSACTION failed: %hs. ... PREPARE TRAN statement not allowed on MSDTC transaction. 8524. 16 ...

Errors 8000 - 8999
Microsoft Distributed Transaction Coordinator (MS DTC) PREPARE acknowledgement failed: %hs. ... PREPARE TRAN statement not allowed on MSDTC transaction. 8524. 16. No ...

Using Marked Transactions (Full Recovery Model)
... databases only to a marked transaction, not to a specific point in time. ... Name the transaction in the BEGIN TRAN statement and use the WITH MARK clause ...

Using Marked Transactions (Full Recovery Model)
... databases only to a marked transaction, not to a specific point in time. ... Name the transaction in the BEGIN TRAN statement and use the WITH MARK clause ...

Lesson 2: Designing Transactions and Optimizing Locking
... issued by the SELECT statement is not held for the duration of the transaction. ... SET TRANSACTION ISOLATION LEVEL READ COMMITTED; BEGIN TRAN; IF EXISTS (SELECT ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!