Thursday, July 26, 2012

Encrypted Stored Procedure

How  to write a encrypted Stored Procedure?

Sometimes we  need to write a stored procedure so that alternative user cannot see written text within  Stored Procedure.

Even you may be ineffective to see the text of the encrypted Stored Procedure in SQL Server  Activity Monitor moreover as by using Sp_helptext SpName methodology.

So what's the command to write encrypted stored procedure.

Let See


CREATE PROCEDURE MyEncrypteSP_cnetcode
WITH ENCRYPTION
AS
SELECT *
FROM cnetcode.user
UNION
SELECT *
FROM cnetcode.user
GO
-- Execute SP
EXEC MyEncrypteSP_cnetcode
GO

:))

17 comments:

  1. Its a good post buddy. Keep it up.

    ReplyDelete
  2. thank you for sharing this information

    ReplyDelete
  3. Thanks for that, really helpful especially for those of us with small businesses and prying employees!

    ReplyDelete
  4. Am not too au fait with coding and stuff so your blog has become pretty useful! Keep up the great work!

    ReplyDelete
  5. Hi, Really great effort. Everyone must be read this article. Thanks for sharing.

    ReplyDelete
  6. Very informative, keep posting such good articles, it really helps to know about things :)

    ReplyDelete
  7. Reading this article was an experience. I enjoyed all the information you provided and appreciated the work you did in getting it written. You evidentially did a lot of research.

    ReplyDelete
  8. Gr8ÖKeep it up!!!! Thanks for sharing this.

    ReplyDelete
  9. I am extremely impressed along with your writing abilities, Thanks for this great share.

    ReplyDelete
  10. Very informative post for me as I am always looking for new content that can help me and my knowledge grow better.

    ReplyDelete
  11. Thanks for sharing. I hope it will be helpful to many people that are searching for this topic. Keep posting guys and keep this forum a great place to learn things.

    ReplyDelete
  12. Thanks a million and please continue the rewarding work.

    ReplyDelete
  13. I can see that you possess a degree of expertise on this subject, I would like to hear much more from you on this subject matter – I have bookmarked this page and will return soon to hear additional about it.

    ReplyDelete
  14. I seriously consider this site needs much more attention.

    ReplyDelete
  15. It is pretty worth enough for me. In my opinion, if all website owners and bloggers will make good content as you did then internet will be a lot more useful than ever before.

    ReplyDelete
  16. Great article, Thanks for your great information, the content is quiet interesting. I will be waiting for your next post.

    ReplyDelete
  17. I really appreciate your professional approach. These are pieces of very useful information that will be of great use for me in future.

    ReplyDelete