USE DB_Encrypt_DemoGO--创建证书CREATE CERTIFICATE cert_Demo --证书名称ENCRYPTION BY PASSWORD = 'asdfG,
Microsoft Office Professional Plus 2007!!!' --加密证书的密码WITH Issue = 'DB_Encrypt_Demo Database Encryption Certificate',
Windows 7 Pro 64bit,--证书主题START_DATE = '3/14/2011',
Office 2010 Keygen, EXPIRY_DATE = '10/20/2012'--起止日期GO --查看当前数据库中的证书use DB_Encrypt_Demogo--查看证书SELECT name,
Microsoft Office 2007 Standard Activation Key, pvt_key_encryption_type_desc,
Windows 7 X64 Key, issuer_nameFROM sys.certificates----结果返回/*name pvt_key_encryption_type_desc issuer_namecert_Demo ENCRYPTED_BY_PASSWORD DB_Encrypt_Demo Database Encryption Certificate*/