摘要： 在源 SQL Server 上运行以下脚本。此脚本可在 master 数据库中创建名称分别为 sp_hexadecimal 和 sp_help_revlogin 的两个存储过程。请在创建完过程之后继续执行第 2 步。注意：下面的过程取决于 SQL Server 系统表。这些表的结构在 SQL Server 的不同版本之间可能会有变化，请不要直接从系统表中选择。 ----- Begin Script, Create sp_help_revlogin procedure -----USE masterGOIF OBJECT_ID ('sp_hexadecimal') IS NOT 阅读全文

摘要： USE NorthWindGOIF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimalGOCREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUTASDECLARE @charvalue varchar (514)DECLARE @i intDECLARE @length intDECLARE @hexstring char(16)SELECT @charvalue = 阅读全文

摘要： use msdbALTER TABLE [backupmediafamily] DROP CONSTRAINT FK__backupmed__media__0A688BB1;ALTER TABLE [backupset] DROP CONSTRAINT FK__backupset__media__10216507;ALTER TABLE [backupfilegroup] DROP CONSTRAINT FK__backupfil__backu__14E61A24;ALTER TABLE [backupfile] DROP CONSTRAINT FK__backupfil__backu__19 阅读全文

摘要： use msdbALTER TABLE [restorefile] drop CONSTRAINT FK__restorefi__resto__00DF2177;ALTER TABLE [restorefilegroup] drop CONSTRAINT FK__restorefi__resto__02C769E9;ALTER TABLE [backupmediafamily] drop CONSTRAINT FK__backupmed__media__72910220;ALTER TABLE [backupset] drop CONSTRAINT FK__backupset__media__ 阅读全文

摘要： USE MSDBALTER TABLE [backupset] drop CONSTRAINT FK__backupset__media__00200768;ALTER TABLE [backupfile] drop CONSTRAINT FK__backupfil__backu__02FC7413;ALTER TABLE [restorehistory] drop CONSTRAINT FK__restorehi__backu__05D8E0BE;ALTER TABLE [restorefile] drop CONSTRAINT FK__restorefi__resto__07C12930; 阅读全文