Red Gate forums :: View topic - Transaction Level
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

Transaction Level

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



Joined: 11 Dec 2012
Posts: 3

PostPosted: Tue Dec 11, 2012 7:51 pm    Post subject: Transaction Level Reply with quote

I am having issues when trying to execute a compare script between two databases which contain stored procedures with ADSI open queries. The problem is due to the fact that SQL Compare generates the following line:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

In order to get the script to run, i have to manually change the line to:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

After I make that change, it works just fine. I was hoping that changing the Transaction Level in the Application Options to Read Uncommitted would take care of this so i didnt have to do this each time, but it will not work...

Am i missing something? How can i set SQL Compare to generate the Read Uncommitted line rather than the Serializable line?

Thanks!
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Dec 12, 2012 12:42 am    Post subject: Reply with quote

Have you tried changing the Transaction Isolation Level in the tool's Application Options?
Back to top
View user's profile Send private message Send e-mail
ps_md



Joined: 11 Dec 2012
Posts: 3

PostPosted: Wed Dec 12, 2012 1:40 pm    Post subject: Reply with quote

Quote:
Have you tried changing the Transaction Isolation Level in the tool's Application Options?


Yes.

The behavior is odd though. If I try to transfer only the objects i know need to have a transaction level of read uncommitted, then the script is generated correctly. However, if i include additional objects the transaction level goes back to serializable.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Thu Dec 13, 2012 1:03 pm    Post subject: Reply with quote

Hi ps_md, sorry that you have encountered a problem.

A support call has been created for you, call reference F0067636.

Would it be possible to send an e-mail to this e-mail address, support@red-gate.com and include the above call reference number in the subject field of the e-mail.

Could you please attach either a SQL Compare Snapshot of each data source or include examples of the database objects that are affected by the problem you have reported? Please include screen shots if you think this will help.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
ps_md



Joined: 11 Dec 2012
Posts: 3

PostPosted: Thu Dec 13, 2012 1:42 pm    Post subject: Reply with quote

I have sent in an email with an example object attached per your request.
Thank you for your help!
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