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.