SQL Compare 10

Could not enlist in a distributed transaction

SQL Compare may display this message if you're updating a stored procedure that references objects across a linked server, and the database system on the linked server does not support the same transaction isolation levels as SQL Server.

To prevent other schema modifications from taking place at the same time as the deployment, SQL Compare sets the transaction isolation level to SERIALIZABLE. To run the deployment SQL script on the target database, you may need to change the transaction isolation level. To do this, open the script in your SQL application, and find this line:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

Change this to:

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

You should take precautions to make sure no changes are made to the target database structure when you run the deployment SQL script.


Didn't find what you were looking for?