Unencrypt Encrypted Stored Procedures

• AndrewSQLDBA

  SSC-Insane

  Points: 21829

  More actions

  June 29, 2010 at 10:18 am

  #141145

  Hello Everyone

  I have some stored procedures that have been encrypted by someone, that I think did not know what they were doing, and does not have the original code. Thankfully that person is no longer here.

  Is there a way to either un-encrypt the encrypted code, or to see it in something like profiler?

  Thank you in Advance

  Andrew SQLDBA

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  June 29, 2010 at 10:29 am

  #1186515

  Hi Andrew,

  I googled around: http://searchsqlserver.techtarget.com/tip/Decrypt-encrypted-stored-procedures

  As a fellow DBA I would consider using some form of source control for your SQL code.

  RedGate http://www.red-gate.com/products/SQL_Source_Control/index.htm have a beta version which I find very useful/intuitive/awesome!

  😉

  HTH,

  GSC

  gsc_dba