Hi Rasmus,

it is possibly to simplify your script up to one select statement ;-):

SELECT 'EXEC sp_addsrvrolemember '''+pr.name+''', '''+pm.name+''''

FROM sys.server_role_members AS rm

JOIN sys.server_principals AS pm ON rm.role_principal_id=pm.principal_id

JOIN sys.server_principals AS pr ON rm.member_principal_id=pr.principal_id

WHERE pr.name <> 'sa'

AND pr.name NOT LIKE 'NT SERVICE%'

AND pr.name NOT LIKE 'NT AUTHORITY%'

Kind regards,

Andrei