Visualizing the content of encrypted stored procedures
Probably you were a bit curious about it and decided to click here, right? This is a very recurrent question on Microsoft forums, where people who maybe by mistake encrypted all of the stored procedures, or maybe you support a 3rd party application and there is an particular stored procedure killing the performance of your server and you just wanna know what the same is doing?
Independent of what you want to do, let me show you here how can you manage to see the content of an encrypted procedure.
Let’s suppose that you have this stored procedure created.
In Management Studio, you can see it that it is encrypted.
sp_helptext is also not helping you.
Well, if you really want to see it, here is the thing. Download SQL Prompt from Red-Gate. After you have downloaded and installed the tool, restart your Management Studio and scrool the mouse over the procedure name as you can see in the below screen.
When you see the procedure name popping up, just click in the hyperlink created and you will be able to see the procedure text even if it was encrypted.
Well, from one side o fthe things this can be very handy, but also this can bring problems, where things should not be seen.
I hope you liked and see you around
Posted on March 1, 2018, in Dicas, Red Gate, Scripts, SQL Server, VirtualPass and tagged decrypt stored procedure, how to see encrypted procedure text, Seeing encrypted procedure, SQL Prompt. Bookmark the permalink. Leave a comment.