Comments
Sort by recent activity
If you use the Management Studio to script the offending default on the two databases, you will see that one has double-parens and one doesn't.
If you then use the Redgate Synchronization Wizard either direction, the two will correctly match following the operation. However, if you instead simply attempt to drop and recreate the default with the desired number of parens, it will have no affect. Re-scripting the default will show that the attempt was futile.
Obviously, there's some obscure SQL setting somewhere that the Synchronization Wizard is aware of and can fix. I have been trying to find this setting, so far to no avail.
I want to know how the Synch wizard does it, because it's not always feasible to blindly synch two databases, and the script generated by the synch wizard doesn't seem to have any clues within it. / comments
If you use the Management Studio to script the offending default on the two databases, you will see that one has double-parens and one doesn't.
If you then use the Redgate Synchronization Wizard ei...