Anil Singh | Code-sample.com

Before create a symmetric key, you first setup your database’s master key and certificate and this master key and certificate help us to protect of your  symmetric  key store using the  ALGORITHM   AES_256. In the below examples, I am using a default master key password is System!123 and the certificate name is Certificate_demo . The following steps as given below, --====================================== --MASTER KEY ENCRYPTION WITH PASSWORD --======================================= CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'System!123' GO --=============================== --OPEN MASTER KEY --============================== OPEN MASTER KEY DECRYPTION BY PASSWORD = 'System!123' GO --============================= --CREATE CERTIFICATE --================================== CREATE CERTIFICATE Certificate_demo WITH SUBJECT = 'Certificate_demo' GO --================================================...