sql 数据库主密钥和证书的管理

创建

USE master;    
GO   
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'kk_2012@';    
GO   
CREATE CERTIFICATE Cert_kk_db2_mssqlserver   
WITH SUBJECT = 'Cert_kk_db2_mssqlserver',    
START_DATE = '2015-06-01',EXPIRY_DATE = '2018-06-01';   
GO   
BACKUP CERTIFICATE Cert_kk_db2_mssqlserver    
TO FILE = 'C:\Databases\Cert_kk_db2_mssqlserver.cer';    
GO   

查询

USE MASTER
go
SELECT * FROM sys.symmetric_keys

更改key

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'kk_2012@';  
GO  

##https://msdn.microsoft.com/zh-cn/library/ms186937.aspx