Red Gate forums :: View topic - "Get latest" and isolation level serializable conflict
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

"Get latest" and isolation level serializable conflict

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
wtjones



Joined: 08 Jan 2008
Posts: 14

PostPosted: Tue Mar 15, 2011 6:44 pm    Post subject: "Get latest" and isolation level serializable conflict Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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


Powered by phpBB © 2001, 2005 phpBB Group