• This should do it

    CREATE TABLE #srvroles(ServerRole VARCHAR(20), Membername VARCHAR(200), MEMBERSID VARBINARY(MAX))

    GO

    INSERT #srvroles EXEC sp_helpsrvrolemember

    SELECT 'EXEC master..sp_addsrvrolemember @loginame = N'+''''+MemberName+''''+','+'@rolename = N'+''''+ServerRole+''''

    FROM #srvroles

    GO

    DROP TABLE #srvroles