Unencrypting Encrypted SQL stored procedures.

  • Jeremy P wrote in his article Crash, that he submitted to the contest, that he found a script to unencrypt SQL stored procedures.  We encrypt all of out stored procedures, then need to know what version of the procedure is on production.  I would love it if there is a way to unencrypt stored procedures.  Does any one know how to do this?  Of course the other issue is how to keep straight the versions of stored procedures that are on our production, test and development databases?


    cwiney

  • Native SQL encryption is not all that robust and there's a few tools around to do this although I've lost most my old links.  You can start here:  http://www.securiteam.com/tools/6J00S003GU.html

    I can't speak much to the versions as we don't do a lot of development here but putting some sort of Change Management and Documentation process in place, whether it's a simple spreadsheet or a complicated DB Application is always a good thing.   

     

    My hovercraft is full of eels.

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

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