"Get latest" and isolation level serializable conflict

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

"Get latest" and isolation level serializable conflict

Postby wtjones » Tue Mar 15, 2011 6:44 pm

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: Select all
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: Select all
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.
wtjones
 
Posts: 14
Joined: Tue Jan 08, 2008 4:27 pm

Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 1 guest