Red Gate forums :: View topic - "Get latest" and isolation level serializable conflict

Go to product documentation

SQL Source Control 2 forum

"Get latest" and isolation level serializable conflict

Search in SQL Source Control 2 forum

Jump to:

Author

Message

wtjones

Joined: 08 Jan 2008
Posts: 14

Posted: Tue Mar 15, 2011 6:44 pm Post subject: "Get latest" and isolation level serializable conflict

I am using SQL Source Control_2.0.10.4_x86_r155986.exe

After answering all the questions on the "get latest" conflict screen I hit "get latest" to push them out and I was halted on step 2 "Applying schema changes to database" with error:

Code:

The requested operation could not be performed because OLE DB provider "Microsoft.ace.OLEDB.12.0" for linked server "(null)" does not support the required transaction interface.

I opened the SSC generated script via the link on the error screen "Manually edit the script" and noticed this at the beginning:

Code:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

It is trying to create one of our views that uses OPENROWSET and OLE DB references cannot be used with SERIALIZABLE. I manually changed it to READ COMMITTED and the script worked fine.

Possible solutions:

1) Switch entire file to READ COMMITTED if OPENROWSET is found

2) Move any objects with OPENROWSET into a separate transaction.

Display posts from previous:

	All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum