Red Gate forums :: View topic - [650] You can only specify the READPAST lock in the READ COM
Return to www.red-gate.com RSS Feed Available

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

[650] You can only specify the READPAST lock in the READ COM

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
kendos



Joined: 07 Jun 2007
Posts: 3

PostPosted: Wed Jun 22, 2011 9:19 am    Post subject: [650] You can only specify the READPAST lock in the READ COM Reply with quote

[650] You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

Get this error when trying to update a database hosted on a server that has replication enabled for that server.

Using SQL Compare 7 if that makes a difference...

Thanks for any guidance.

Ken.
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Thu Jun 23, 2011 6:25 pm    Post subject: You can only specify the READPAST lock in the READ COM Reply with quote

Thanks for contacting Red Gate.

I'm fairly sure that v7 has this option, but if you click the options tab when you create a new project, you can check the box for 'do not use transactions in synchronisation scripts'. This should stop you getting that error, however, something to bear in mind is that it wont roll back if the script fails so you need to make sure you're happy with it before you synchronise.

I hope this answers your question, if you're unsure whether or not you are eligible for more recent versions of the tool, give is a call and speak to the sales team, or you can email sales@red-gate.com.

I hope this helps.

Thanks.
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Mon Oct 17, 2011 7:13 pm    Post subject: Reply with quote

Or... you can set the transaction isolation level in the application if you use SQL Compare 9.5. See

http://www.red-gate.com/MessageBoard/viewtopic.php?p=51312#51312

for more details.

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
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