RC4 Encryption in a Stored Procedure

  • jgama

    Mr or Mrs. 500

    Points: 509

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jgama/rc4encryptioninastoredprocedure.asp

  • reach_nag


    Points: 19


    We have a performance issue with data encryption.

    Currently we are Opening((OPEN SYMMETRIC KEY sk_Enc).

    & Closing(CLOSE SYMMETRIC KEY sk_Enc) the encryption keys in every Stored Procedure.

    Is there any way we can open encryption Key only once for all SP's.

    If possible,please how to implement that.

    thanks in advance.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply