Decrypting Sql 2005 SPs made easy
· 2009-03-25 15:05 by Thijs Kroesbergen for Brokenwire.NET
Today I ran across a problem where I desperately needed to peek inside a stored procedure used by Team Foundation Server. The only trouble was that the stored procedure was created with the “WITH ENCRYPTION” clause appended, so I couldn’t see the source.
To decrypt the stored procedure I used a stored procedure called dbo.sp_SpDeObfuscation, which can be found here and/or downloaded here.
Please keep in mind that you need to run the SP from an DAC (Dedicated Admin Connection)
Use VPC fullscreen on your large screen Quick Visual Studio Tip
Thank you ! Thank you ! Thank you ! Thank you !
— Max 2011-11-04 20:09 #