切换镜像之前,获取具有sysadmin'权限的帐号脚本
DECLARE @sql VARCHAR(MAX)
SET @sql = ''
SELECT @sql = @sql + 'EXEC sp_addsrvrolemember ''' + a.name
+ ''', ''sysadmin'';' + CHAR(10)
FROM SYS.SYSLOGINS a
JOIN SYS.SERVER_PRINCIPALS b ON a.sid = b.sid
WHERE b.type_desc = 'SQL_LOGIN'
AND a.sysadmin = 1
AND b.is_disabled = 0
AND a.name <> 'sa'
PRINT @sql