我正在开发第三方数据库.
当我尝试通过右键单击,CREATE TO然后再到NEW QUERY EDIT WINDOW来查看视图的定义时,我收到一个错误:
This property may not exist for this object or may not be retrievable
due to insufficient access rights. The text is encrypted.
解决方法
另一个可以用来动态解密加密对象的第三方工具是Red Gate的sql提示:
http://www.red-gate.com/products/sql-development/sql-prompt/features
http://www.red-gate.com/products/sql-development/sql-prompt/features
将鼠标悬停在存储过程上将允许您查看解密的创建脚本.
免责声明:这个工具是商业的(14天免费试用),我在Red Gate工作.