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