修复孤立用户

--use 库名

DECLARE @loop INT

DECLARE @USER sysname

IF
       OBJECT_ID('tempdb..#Orphaned') IS NOT NULL

BEGIN

DROP TABLE #orphaned

END

CREATE TABLE #Orphaned (UserName sysname, UserSID VARBINARY(85),IDENT INT IDENTITY(1,1))

INSERT  INTO #Orphaned

   EXEC SP_CHANGE_USERS_LOGIN 'report';

IF(SELECT COUNT(*) FROM #Orphaned) >0

BEGIN

SET @loop=1

WHILE @loop <= (SELECT MAX(IDENT) FROM #Orphaned)