Stored Prrocedure Comparison shows Text was encrypted

Scott_Malmsten2135

When comparing the differences between two databases (DEV & TEST), the DEV version shows a message of Text was encrypted. It does not generate the difference script I was expecting. How can I get the script to generate instead of the message?

sam.blackburn

The most likely issue is that you might not have the required VIEW SERVER STATE permissions on your dev instance.  SQL Compare attempts to decrypt encrypted objects, but will show this message if it was unable to do so (or if the option was disabled).  The most common reason for being unable to decrypt an object is insufficient permissions on the server.