Gerar Logins com Senhas SQL Server

SELECT 'IF(SUSER_ID('+QUOTENAME(SP.name,'''')+') IS NULL)BEGIN CREATE LOGIN '+QUOTENAME(SP.name)+
       CASE WHEN SP.type_desc = 'SQL_LOGIN'
            THEN ' WITH PASSWORD = '+CONVERT(NVARCHAR(MAX),SL.password_hash,1)+' HASHED'
            ELSE ' FROM WINDOWS'
       END + ';/*'+SP.type_desc+'*/ END;' 
       COLLATE SQL_Latin1_General_CP1_CI_AS
FROM sys.server_principals AS SP
LEFT JOIN sys.sql_logins AS SL
    ON SP.principal_id = SL.principal_id
WHERE SP.type_desc IN ('SQL_LOGIN','WINDOWS_GROUP','WINDOWS_LOGIN')
   AND SP.name NOT LIKE '##%##' 
   AND SP.name NOT LIKE '%NT SERVICE\%' 
   AND SP.name NOT LIKE '%WIN-%' 
   AND SP.name NOT LIKE '%NT AUTHORITY\%' 
   AND SP.name NOT IN ('SA','NT AUTHORITY\SYSTEM')