Encrypt Stored Procedure

Posted by Srinathgb under ASP.NET on 7/6/2013 | Points: 10 | Views : 801 | Status : [Member] | Replies : 1
Hello Team

Can you we encrypt stored procedure while downloading to script file?

While generating script file is it possible to encrypt stored procedure and while again loading into database should decrypt.

Srinath




Responses

Posted by: lakhansin-22735 on: 7/8/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

As per my experience, always you have to store your encrypted stored procedure script at safe location to avoid unnecessary task and issues.
Second, by doing lots of R&D, I have found the way by which we can decrypt a encrypted stored procedure.
Kindly, see the below link and I used the same and its works for me.

http://jongurgul.com/blog/sql-object-decryption/


Lakhan Singh
Tech Lead
BeyondKey System Pvt. Ltd.
Indore, M.P.
India

Srinathgb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response