Decrypting Sql 2005 SPs made easy
· Mar 25, 02:05 PM 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)
- Permalink -
Use VPC fullscreen on your large screen Quick Visual Studio Tip
