What are the challenges you face when working across database platforms? Take the survey
Options

Stored Prrocedure Comparison shows Text was encrypted

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?

Tagged:

Answers

  • Options
    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.
    Software Developer
    Redgate Software
Sign In or Register to comment.