MSSQL 的 Stored Procedure 显示 The text is encrypted

Question

MSSQL 的 Stored Procedure 显示 The text is encrypted 怎么办?

今天遇到一个远古时期前人(已离职,不知道是谁,我OO你的XX,Fxxx!)遗留的 Stored Procedure,发现有问题需要做调整,结果发现出现 The text is encrypted

我爬了很多文都说无解,请问大神们有机会解决这问题吗?

Property TextHeader is not available for StoredProcedure '[dbo].[xxx_Proc]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo)

Answer 1

https://www.cnblogs.com/wghao/archive/2012/12/30/2837642.html