Decrypt an SP?

• fqureshi786

  Old Hand

  Points: 387

  More actions

  July 30, 2005 at 9:59 pm

  #89320

  Hi

  There's a script on this Site about decrypting a stored Procedure. I tested it and it works fine, however, it has two limitations that i came across and i was wondering if anyone has tried this script and how they may have over come it.

  1. First, this script captures the binary code from ctext column of syscomments and drop the original proc and then creates a new one without encryption. Can we avoid dropping the original, and may be just display the decrypted code?

  2. in some cases, syscomments table have multiple rows for an SP and so the sub-query returns more than one, which of course is not desired. So the execution fails, however, the original SP is already dropped by now. If this were to be done within a TRANSACTION, it probably won't drop the original SP.

  Any ideas? or is there an updated Decrypt Script/proc. one of the guys at my company left and he had created a few Procs with Encryption. While i tested this script in my dev environment, it was fine, but in the production, all the SPs have multiple rows in the syscomments table, hence its failing to decrypt.

  Thanks

  Faisal

• Peet Schultz-223955

  Valued Member

  Points: 68

  More actions

  August 1, 2005 at 6:47 am

  #578481

  Have a look at :  http://www.geocities.com/d0mn4r/dSQLSRVD.html or http://www.sql-shield.com/decrypt-stored-procedure.html

   

  Good luck

  Peet Schultz