un encrypting a stored proc 1

[jaylou]

I have an application that runs an encrypted SP. it is failing due to a data type. Is there a way for me to unEncrypt the Procedure so I can see where it is failing?

TIA,
Joe

 

[Jamfool]

http://www.1javastreet.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

There are two procs I’ve seen and used. One is DECRYPT2K and the other is DECRYPTSP2K.

Both will unencrypt procs. Be aware that they will TRY to unencrypt the ones in your db,
so take a backup and test it in dev environment.

I dont think you can unencrypt procs larger than 4000 chars. if you try and unencrypt them it will throw out an error and recreate an invalid proc.

Also note that Iam not responsible in any way regarding decryption or damage caused by using the above ref procs. I assume also that you are entitled to unencrypt them.