Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

decrypt an encrypted stored procedure

Status
Not open for further replies.

TWillard

Programmer
Joined
Apr 26, 2001
Messages
263
Location
US
I have this task to configure a software product that uses SQL Server as its database. However, much of their code is stored in encrypted stored procedures in the database. Does anyone know how to decryt an encrypted stored procedure? This product is suposed to be configurable. However, they have their code hidden. I can't understand this why they would do this, especially since they do not provide any detailed manuals for configuration reference.
 
Hi,

This is from the Book online:

"After a stored procedure is encrypted, its definition cannot be decrypted and cannot be viewed by anyone, including the owner of the stored procedure or the system administrator."


Kim
 
Someone just asked this recently. SQL Server has no capability. You're supposed to have the source.

However, there are a couple of shareware/freeware tools out there that smart people have written.

Go to your favorite search engine and look for them, or search back through this forum a couple of weeks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top