Home > IT Answers > Security > Related to SQL server 2005
ITIndustry
5 pts.
 Related to SQL server 2005
Decryption, SQL Server 2005, SQL stored procedures, Stored Procedures
When we write store procedure it is encrypt by --with encrypt tag means it will locked it doesn't show sp so how it will be DECRYPT?

Software/Hardware used:
Software
ASKED: June 4, 2011  4:39 AM
UPDATED: June 10, 2011  3:24 PM
RELATED QUESTIONS
Answer Wiki:
The SQL Server engine has the keys needed to decrypt the procedure so that it can run the code within the procedure, is just won't show it to you. If you need to decrypt procedures which have been encrypted within your database just google for "SQL Server decrypt stored procedure" and you'll get a bunch of applications which can log into your SQL Server and decrypt the stored procedures in just a few seconds. The keys to decrypt the stored procedures were cracked log ago and haven't been changed so it's pretty easy to decrypt them.
Last Wiki Answer Submitted:  June 10, 2011  3:24 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _