"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.

"Get latest" and isolation level serializable conflict

Postby wtjones » Tue Mar 15, 2011 5: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

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

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests