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)
![](https://www.brokenwire.net/bw/images/79.png)
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 #