January 10, 2011 at 5:15 am
Upto SQL server 2005, the 'decrypt' function is working. In 2008, that is not working. I need to change the scripts to support 2008. Is there any alternate for 'decrypt' function in 2008?
Please help me to solve this issue...
Thank you in Advance.
January 10, 2011 at 6:04 am
In the past I needed to decrypt procedures that were written with SQL Server 2000 and SQL Server 2005. I had to invest few minutes to look for a script that does it. The decryption was very simple and this of course raised the question – why would anyone encrypt the procedure if it so easy to decrypt them? I never needed to decrypt a procedure using SQL Server 2008, but just out of curiosity I used Google to search the phrase “decrypt stored procedures 2008”. Got few scripts but didn’t test them. Did you check the scripts from Google?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply