Error 7391

Troubleshooting SQL Server

Troubleshooting

Error 7391

Severity Level 16
Message Text

The operation could not be performed because the OLE DB provider '%ls' was unable to begin a distributed transaction.

Explanation

This error can occur while processing an INSERT, UPDATE, or DELETE statement inside an explicit or implicit transaction. This indicates that the OLE DB provider does not support distributed transactions, which is needed for data modification statements inside an explicit or implicit transaction. A data modification statement can be executed against such a provider only in the case where the statement is a transaction by itself.

Action

Verify that the OLE DB provider specified supports distributed transactions. If the provider does not support distributed transactions, rewrite the data modification statement not to use distributed transactions.

See Also

Distributed Queries