Kopiera användare

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' + ' ,SID = ' + CONVERT(NVARCHAR(MAX),SL.sid,1)
            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 IN ('SA');