摘要:
SQL2008,SQL2005存储过程解密第一步操作步骤:'程序'->'Sql Server2005'-> '配置工具'-> 'Sql Server 外围应用配置器'-> '功能的外围应用配置器'-> 'DataBase Engine'-> 'DAC' -> '启用远程DAC'第二步:启动SQL Server Browser 服务第三部使用DAC模式登陆(关键就在这个地方)1 登陆SQL Server Management S 阅读全文
摘要:
--主体USE master;--DROP MASTER KEY;--统一主密钥CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'JiuBang_ZB_2008@3g.cn';GO--统一的登录密码CREATE LOGIN MIR_M_LOGIN WITH PASSWORD = 'JiuBang_JB_2008@3g.cn';GO--统一的登录用户名CREATE USER MIR_M_USER FOR LOGIN MIR_M_LOGIN;GO---------------------------USE master;CREA 阅读全文
摘要:
--主体USE master ;GO --创建主密钥 DROP ENDPOINT Endpoint_do DROP CERTIFICATE MASTER_Cert DROP MASTER KEYCREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456' ;GO --创建证书 CREATE CERTIFICATE MASTER_Cert WITH SUBJECT = 'MASTER_Certificate', START_DATE = '01/01/2011' ; GO --创建端点 CREATE END 阅读全文