Decrypt a symmetric key and makes it available for use.
Syntax: OPEN SYMMETRIC KEY Key DECRYPTION BY decrypt_option decrypt_options: CERTIFICATE certificate [WITH PASSWORD = 'password'] ASYMMETRIC KEY asym_key [WITH PASSWORD = 'password'] SYMMETRIC KEY decrypting_Key PASSWORD = 'decryption_password' Key: certificate Certificate whose private key will be used to decrypt the symmetric key. asym_key An asymmetric key whose private key will be used to decrypt the symmetric key. password Password that was used to encrypt the private key of the certificate or asymmetric key. decrypting_key Key that will be used to decrypt the key being opened. decryption_password The password that was used to protect the symmetric key.
An open key will continue to be available until it is either explicitly closed or the session is terminated.
If the symmetric key was encrypted with another key, that key must be opened first.
OPEN SYMMETRIC KEY SymKeySS64
DECRYPTION BY CERTIFICATE Cert02;
"Success is not the key to happiness. Happiness is the key to success. If you love what you are doing, you will be successful." - Herman Cain
CREATE SYMMETRIC KEY
CLOSE SYMMETRIC KEY
ALTER SYMMETRIC KEY
DROP SYMMETRIC KEY