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