SQLServerCentral / Discuss Content Posted by Joseph Gama / Article Discussions / Article Discussions by Author / RC4 Encryption in a Stored Procedure / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:52:06 GMT20RE: RC4 Encryption in a Stored Procedurehttp://www.sqlservercentral.com/Forums/Topic19589-100-1.aspxHi,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.RaoFri, 04 Jul 2008 11:30:27 GMTreach_nagRC4 Encryption in a Stored Procedurehttp://www.sqlservercentral.com/Forums/Topic19589-100-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/jgama/rc4encryptioninastoredprocedure.asp>http://www.sqlservercentral.com/columnists/jgama/rc4encryptioninastoredprocedure.asp</A>Sun, 28 Dec 2003 00:00:00 GMTjgama