sql server数据库客户迁移服务器帆软报表注意事项

帆软迁移SQLServer首先创建导出SQLServer数据库中登录名和的SQL：以SQLServerManagementStudio此SQL----注：v71_sp1DROPPROCEDURE@binvaluevarbinary(256),@hexvaluevarchar(514)OUTPUTDECLARE@iintDECLARE@lengthintSELECT@charvalue=SELECT@i=SELECT@hexstring='0123456789ABCDEF'WHILE(@i<=@length)DECLARE@tempintintDECLARE@ intintSELECT@ int=FLOOR(@tempint/16)SELECT@secondint=@tempint-(@ SELECT@charvalue=@charvalue+SUBSTRING(@hexstring,@ int+1,1)+SUBSTRING(@hexstring,@secondint+1,1)SELECT@i=@i+1SELECT@hexvalue=@charvalueIFOBJECT_ID('sp_help_revlogin')ISNOTNULLDROPPROCEDUREsp_help_revloginCREATEPROCEDUREsp_help_revlogin@login_namesysname=NULLASDECLARE@namesysnameDECLARE@hasaccessintDECLARE@denyloginintDECLARE@is_disabledintDECLARE@PWD_stringvarchar(514)DECLARE@SID_varbinaryvarbinary(85)DECLARE@SID_stringvarchar(514)DECLARE@tmpstrvarchar(1024)DECLARE@is_policy_checkedvarchar(3)DECLARE@defau bsysnameIF(@login_nameISNULL)DECLARElogin_cursCURSORFORSELECTp.sid,,p.type,p.is_disabled,p.default_database_name,l.hasaccess,l.denyloginON(=)WHEREp.typeIN('S','G','U')AND<>'sa'SELECTp.sid,,p.type,p.is_disabled,p.default_database_name,l.hasaccess,l.denyloginON(=)WHEREp.typeIN('S','G','U')AND=@login_nameOPENlogin_cursFETCHNEXTFROMlogin_cursINTO@SID_varbinary,@name,@type,@is_disabled,@defau @hasaccess,@denyloginIF(@@fetch_status=-1)CLOSElogin_curs RETURN-1SET@tmpstr='/*sp_help_revloginscript'PRINT@tmpstrSET@tmpstr='**Generated'+CONVERT(varchar,GETDATE())+'on'+@@SERVERNAME+PRINT''IF(@@fetch_status<>-2)PRINTSET@tmpstr='--Login:'+@namePRINT@tmpstrIF(@typeIN('G',BEGIN--NTauthenticatedSET@tmpstr='CREA OGIN'+QUOTENAME(@name)+'FROMWINDOWSWITHDEFAULT_DATABASE=['+@defau b+']'ELSEBEGIN--SQLServer--obtainpasswordandSET@PWD_varbinary=CAST(LOGINPROPERTY(@name,'PasswordHash')ASvarbinary(256))EXECsp_hexadecimal@PWD_varbinary,@PWD_stringOUT--obtainpasswordpolicySELECT@is_policy_checked=CASEis_policy_checkedWHEN1THEN'ON'WHEN0THENELSENULLENDFROMsys.sql_loginsWHEREname=SELECT@is_expiration_checked=CASEis_expiration_checkedWHEN1THEN'ON'WHEN0THEN'OFF'ELSENULLENDFROMsys.sql_loginsWHEREname=@nameSET@tmpstr= OGIN'+QUOTENAME(@name)+'WITHPASSWORD=' b+IF(@is_policy_checkedISNOTNULL)SET@tmpstr=@tmpstr+',CHECK_POLICY='+@is_policy_checkedIF(@is_expiration_checkedISNOTNULL)SET@tmpstr=@tmpstr+',CHECK_EXPIRATION='+@is_expiration_checkedIF(@denylogin=BEGIN--loginisdeniedSET@tmpstr=@tmpstr+';DENYCONNECTSQLTO'+QUOTENAME(@name)ELSEIF(@hasaccess=BEGIN--loginexistsbutdoesnothaveSET@tmpstr=@tmpstr+';REVOKECONNECTSQLTO'+QUOTENAME(@name)IF(@is_disabled=1)BEGIN--loginisdisabledSET@tmpstr=@tmpstr+';ALTERLOGIN'+QUOTENAME(@name)+'DISABLE'FETCHNEXTFROMlogin_cursINTO@SID_varbinary,@name,@type,@is_disabled,@defau @h