Options
--Text was encrypted - but it is not!
Ozzie
Posts: 46 Bronze 5
Hey Red Gate,
I am comparing 3 servers together. Server B, in one compare against Server A, has all of my column default constraint values visible. However when I compare Server B to Server C , it says all of Server B's default column constraints are encrypted.
This happened today in 7.0 - and is still happening with the 7.1 update I downloaded a moment ago after a reboot and a prayer. What can I do to correct this - this is a pretty impactful situation for me?
Thanks,
Doug
I am comparing 3 servers together. Server B, in one compare against Server A, has all of my column default constraint values visible. However when I compare Server B to Server C , it says all of Server B's default column constraints are encrypted.
This happened today in 7.0 - and is still happening with the 7.1 update I downloaded a moment ago after a reboot and a prayer. What can I do to correct this - this is a pretty impactful situation for me?
Thanks,
Doug
Comments
In both scenarios, are you connecting to server B using the same account and project options?
Also, what account are you using to connect to the other databases?
It might be worth checking the permissions; we have a kb document to outline the minimum permissions required for SQL Compare:
http://www.red-gate.com/supportcenter/C ... 000072.htm
So where is this KB article? it's a dead link
This is the current one:
http://www.red-gate.com/supportcenter/C ... quired.htm
Thank You!