导入导出数据库实例上所有登录名角色权限（Import all the login name role permissions on the exported database instance）.doc

导入导出数据库实例上所有登录名角色权限（Import all the login name role permissions on the exported database instance） Import all the login name role permissions on the exported database instance This script is suitable for database instance relocation of user authority for import and export as database migration often appear such problems embarrassed.. RZ...... USE master GO IF, OBJECT_ID (sp_hexadecimal), IS, NOT, NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary (256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514) DECLARE @i int DECLARE @length int DECLARE @hexstring char (16) SELECT @charvalue =0x SELECT @i = 1 SELECT @length = DATALENGTH (@binvalue) SELECT @hexstring =0123456789ABCDEF WHILE (@i @length) BEGIN DECLARE @tempint int DECLARE @firstint int DECLARE @secondint int SELECT @tempint = CONVERT (int, SUBSTRING (@binvalue, @i, 1)) SELECT @firstint = FLOOR (@tempint/16) SELECT @secondint = @tempint - (@firstint*16) SELECT @charvalue = @charvalue + SUBSTRING (@hexstring, @firstint+1, 1) + SUBSTRING (@hexstring, @secondint+1, 1) SELECT @i = @i + 1 END SELECT @hexvalue = @charvalue GO IF, OBJECT_ID (sp_help_revlogin), IS, NOT, NULL DROP PROCEDURE sp_help_revlogin GO CREATE, PROCEDURE, sp_help_revlogin, @login_name, sysname = NULL, AS DECLARE @name sysname DECLARE @type varchar (1) DECLARE @hasaccess int DECLARE @denylogin int DECLARE @is_disabled int DECLARE @PWD_varbinary varbinary (256) DECLARE @PWD_string varchar (514) DECLARE @SID_varbinary varbinary (85) DECLARE @SID_string varchar (514) DECLARE @tmpstr varchar (1024) DECLARE @is_policy_checked varchar (3) DECLARE @is_expiration_checked varchar (3) DECLARE @defaultdb sysname IF (@login_name, IS, NULL) DECLARE login_curs CURSOR FOR SELECT, p.sid, , p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin, FROM Sys.server_principals, P, LEFT, JOIN, sys.syslogins, l ON ( = ) WHERE p.type IN (S,G,U) ANDsa ELSE DECLARE login_curs CURSOR FOR SELECT, p.sid,