"No text is available" in SQL view

If you don't have permissions to decrypt objects in the database, SQL Compare will not be able to get the default value of some columns. This will result in the SQL View showing the message, "No text is available," in lieu of the default value.

If this is the case, make sure you have sysadmin permissions in order to properly decrypt objects.

See here for the full list of required permissions here.

Note: This applies to SQL Compare, SQL Source Control, and SQL Change Automation.

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request