Red Gate forums :: View topic - bug SC-4655 - trace on, trace off
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

bug SC-4655 - trace on, trace off

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



Joined: 30 May 2011
Posts: 3

PostPosted: Wed Nov 14, 2012 6:41 am    Post subject: bug SC-4655 - trace on, trace off Reply with quote

I have been tracking this issue for 18months or so now, and was hoping someone could please update on the progress?

there is a known bug SC-4655 that causes SQL logs and Event logs to be full of errors(or messages) whenever a compare is made.

This is extremely painful when trying to check logs for other errors or simple daily checks.

Could this please be looked at! Shocked
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Fri Nov 16, 2012 12:44 pm    Post subject: Reply with quote

Thank you for your forum post.

This Bug SC-4655 is still unresolved. The SQL Compare Development Team looked into this issue in October 2011 and where not confident in the fix they produced as it was potentially more dangerous when compared to current method or operation.

I have updated the Bug Tracking topic SC-4655 and marked the request for review. I will also request if someone from SQL Compare Development Team can provide an update to this forum post.

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
eddie davis



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

PostPosted: Fri Nov 16, 2012 3:57 pm    Post subject: Reply with quote

Hi

There is a SQL Compare option you could try turning off (as it is enabled by default) the "Decrypt encrypted objects on 2005 and 2008 databases" option and then refresh the comparison.

Edit Project ->Options tab ->Behavior ->second option from the bottom of the list of behavior options.

In the test I performed before posting this update, it reduced the number of DBCC TRACEON/TRACEOFF entries.

The downside disabling this option, if you have encrypted objects in your data sources they will not be compared.

If this works out for you, please thank my colleague, Michelle, who reminded me of the above option.

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