"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: https://documentation.red-gate.com/sc13/requirements/permissions-required-to-use-sql-compare

Note: This applies to both SQL Compare and SQL Source Control.

Was this article helpful?

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