panankx123 |
04-12-2011 04:36 PM |
Office 2007 Pro Plus Key SQL Server 2008中的代码安
--以下语句创建一个非对称密钥asymDemoKeyuse DB_Encrypt_DemogoCREATE ASYMMETRIC Essential asymDemoKey --创建非对称密钥名称WITH ALGORITHM = RSA_512 --加密安全类型ENCRYPTION BY PASSWORD = 'TestASYM123, Office 2007 Pro Plus Key!' --密码--查看当前数据库中的非对称密钥use DB_Encrypt_DemogoSELECT identify, Office Professional Plus 2010 Key, algorithm_desc, Windows 7 32bit, pvt_key_encryption_type_descFROM sys.asymmetric_keys----结果返回/*name algorithm_desc pvt_key_encryption_type_descasymDemoKey RSA_512 ENCRYPTED_BY_PASSWORD*/
|