encrypted procedure 1

[mkey]

Hi All,
I encrypted my procedure to check something. How can I take the encryption out so that I could see my code.
Thanks!!
mkey

 

[chiph]

I don't think this can be done. Sorry.

See if you can find a copy of your stored procedure's source code in a temp directory or the recycle bin.

Chip H.

 

[balves]

I believe that there are a couple of shareware tools / functions that people have written to decrypt a SQL Server stored proc. Hunt around with Google.

One was in SQL Server Magazine a couple of years ago (for SQL Server V6.5; probably still works).

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=14369

 

[aalmeida]

Just recreate the Stored Procedure without the "with Encription" option and that will do it or Run the lter procedure without te "with encription" option, on either case you need to have the original code. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"