Re: how to decrypt an encrypted stored proc in 2005



I was able to make it work on a test stored proc - just few lines in
the code. But I have a very large Stored Proc - probably more than 15
lines in the SysComment table (close to 60000 characters). For this
stored proc, the decrypt sp returns no results. I am not sure if this
is a problem with the decrypt stored proc or there is something else
they may have done to encrypt the sp.

.