Open Master Key

USE Northwind;
GO
–  建立資料庫 master key 來保護接下來建立的憑證
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘P2$$w0rd’
— 若資料庫 Backup/Restore 到其他執行個體，需要先 open 才能使用其加密的其他憑證或鑰匙
— OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘P2$$w0rd’

CREATE CERTIFICATE foo
–   ENCRYPTION BY PASSWORD = ‘password’ 
–若不用密碼就需要先設定 Database Master Key
   WITH SUBJECT = N’測試加解密’,
   EXPIRY_DATE = ’10/31/2026′;

…