August 4, 2010 at 5:52 pm
We create store procedures with "encryption". How can I read the definition using SQl Server Management ?
thanks.
August 4, 2010 at 8:28 pm
You can't. You need to keep a copy of the code unencrypted somewhere.
There are tools that you can get that will decrypt encrypted procedures, but I'm not gonna be responsible for telling you where. You need to find them yourself, just in case someone wants to violate a license agreement and decrypt someone else's code.:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 4, 2010 at 11:10 pm
Yes you cannot. Here is what Microsoft documentation states
Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server. Users who have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users who can either access system tables over the DAC port or directly access database files. Also, users who can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.
This option is not valid for CLR procedures.
Procedures created with this option cannot be published as part of SQL Server replication
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 5, 2010 at 7:32 am
If you could read encrypted stored procedures, what would be the point of encrypting them in the first place....?
August 6, 2010 at 12:40 am
jeff.mason (8/5/2010)
If you could read encrypted stored procedures, what would be the point of encrypting them in the first place....?
May be the reason tat someone encrypted and he want to decrypt 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply