Orphan Users

USE [DBName]
GO


DECLARE @SQLString VARCHAR(6300)
SELECT    @SQLString = ''

SELECT     @SQLString = @SQLString + 'EXEC [dbo].[sp_Change_Users_Login] ''Update_One'','''+[Name]+''','''+[Name]+''' '
FROM     [dbo].[SysUsers]
WHERE     [IsSqlUser] = 1 
AND     (SId IS NOT NULL AND SId <> 0x0) 
AND     SUSER_SNAME(SId) IS NULL

IF LEN(LTRIM(RTRIM(@SQLString)))<>0 
BEGIN
    PRINT(@SQLString)
    EXEC(@SQLString)    
END
GO