SET NOCOUNT ON
SELECT 'EXEC sp_addlogin @loginame = ''' + loginname + ''''
,', @defdb = ''' +  'tempdb'+ ''''
,', @deflanguage = ''' + language + ''''
,', @encryptopt = ''skip_encryption'''
,', @passwd ='
, cast(password AS varbinary(256))
,', @sid ='
, sid
FROM syslogins
WHERE name NOT IN ('sa')
AND isntname = 0

SELECT 'EXEC sp_grantlogin @loginame = ''' + loginname + ''''
FROM syslogins
WHERE loginname NOT IN ('BUILTIN\Administrators')
AND isntname = 1


select 'EXEC sp_addsrvrolemember '''+loginname+''', ''sysadmin'''
from syslogins
where sysadmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''securityadmin'''
from syslogins
where securityadmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''serveradmin'''
from syslogins
where serveradmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''setupadmin'''
from syslogins
where setupadmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''processadmin'''
from syslogins
where processadmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''diskadmin'''
from syslogins
where diskadmin = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''dbcreator'''
from syslogins
where dbcreator = 1
union
select 'EXEC sp_addsrvrolemember '''+loginname+''', ''bulkadmin'''
from syslogins
where bulkadmin = 1

-----------------------------------------
select 'Run these after dbs are created:'

select ' EXEC sp_defaultdb @loginame = ''' + loginname + ''''
,', @defdb = ''' + Coalesce(dbname, 'tempdb') + ''''
FROM syslogins
where name NOT IN ('sa')
AND isntname = 0
----------------------------------------


select ' EXEC sp_defaultdb @loginame = ''' + loginname + ''''
,', @defdb = ''' + Coalesce(dbname, 'tempdb') + ''''
FROM syslogins
WHERE loginname NOT IN ('BUILTIN\Administrators')
AND isntname = 1