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

Forum for users of SQL Compare schema synchronization utility

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

Postby kendos » Wed Jun 22, 2011 9:19 am

[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.
kendos
 
Posts: 3
Joined: Thu Jun 07, 2007 11:20 am

You can only specify the READPAST lock in the READ COM

Postby Sian.Williams » Thu Jun 23, 2011 6:25 pm

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
--------------------------------------
Sian.Williams
 
Posts: 32
Joined: Thu Aug 26, 2010 8:59 pm

Postby David Atkinson » Mon Oct 17, 2011 7:13 pm

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/vi ... 1312#51312

for more details.

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests