Red Gate forums :: View topic - SQL Compare - can I ignore Linked server requirement?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare - can I ignore Linked server requirement?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
shiftbit



Joined: 06 Mar 2013
Posts: 9

PostPosted: Wed Mar 06, 2013 9:15 pm    Post subject: SQL Compare - can I ignore Linked server requirement? Reply with quote

There is one stored procedure that requires a linked server and the deployment will fail.

I get an error similar to this:

[7391] The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "server name here...." was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server "server name here..." returned message "The transaction manager has disabled its support for remote/network transactions.".

Is there a setting to ignore this check, and just apply the changes?
Back to top
View user's profile Send private message
shiftbit



Joined: 06 Mar 2013
Posts: 9

PostPosted: Wed Mar 06, 2013 9:54 pm    Post subject: Reply with quote

I think I found the option I needed - "Dont use transactions", this let me get past the one problem stored procedure thats using a linked server, but if its not configured on my machine, then the change deployment fails.

In this casae, Im trying ti update my local instance with the changes in the DB on the server, and to take/override what I have with everything from that instance.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Mon Mar 11, 2013 12:29 pm    Post subject: Reply with quote

Thanks for updating us. SQL Compare will not recreate linked servers, as they are server-level objects and outside of the database container.

Linked server drivers usually have limits on their capability, for instance they may only support certain isolation levels. You can either disable transactions, or the other option is to specify the isolation level. In most cases, READ COMMITTED with do the job and not have to disable transactions entirely.
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