Encrypt Stored Procedure

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts