RC4 Encryption in a Stored Procedure

• jgama

  Mr or Mrs. 500

  Points: 509

  More actions

  December 28, 2003 at 12:00 am

  #106720

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

• reach_nag

  Grasshopper

  Points: 19

  More actions

  July 4, 2008 at 11:30 am

  #838415

  Hi,

  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.

  Rao