How to view the Store Procedures which has been encrypted

Question

Post reply

How to view the Store Procedures which has been encrypted

dakshinamurthy-655138

SSCertifiable

Points: 5172
More actions
June 24, 2008 at 12:52 am

#103516

Hi,
will any one please let me know, is there any way to get the SP which has been encrypted in SQL Server 2000
With Regards
Daks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

Hope this helps:

http://www.sqlmag.com/Article/ArticleID/95728/sql_server_95728.html

Manu

dakshinamurthy-655138 SSCertifiable Points: 5172 More actions · Answer 2

Hey,

Thank you very much for the reply, but correct me if i am wrong. When i pass the owner and procedure name which has been encrypted, i am not getting the body in the store procedure only 2 lines or some times only the syntax is viewed. Please let me know where i have gone wrong.

With Regards

Dakshina