https://docs.microsoft.com/en-US/troubleshoot/sql/security/transfer-logins-passwords-between-instances
创建存储过程,生成需要的脚本,传输logins和密码:
在[数据库]-->[系统数据库]-->[master]-->[可编程性]-->[存储过程]查看,会生成两个存储过程:sp_hexadecimal和sp_help_revlogin
USE [master]
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE [dbo].[sp_hexadecimal]
(
@binvalue varbinary(256),
@hexvalue varchar (514) OUTPUT
)
AS
BEGIN
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 |