bug SC-4655 - trace on, trace off

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

bug SC-4655 - trace on, trace off

Postby tgibbo » Wed Nov 14, 2012 6:41 am

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! :shock:
tgibbo
 
Posts: 3
Joined: Mon May 30, 2011 6:27 am

Postby eddie davis » Fri Nov 16, 2012 12:44 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eddie davis » Fri Nov 16, 2012 3:57 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest