SELECT a.name,
default_database_name,
d.name,
--SELECT
'USE [master]
GO
ALTER LOGIN [' + a.name + '] WITH DEFAULT_DATABASE=[' + d.name + ']
GO
'
FROM sys.server_principals a
INNER JOIN sys.databases d ON a.name LIKE '%' + d.name + '%'
WHERE (SELECT COUNT (*) FROM sys.databases d WHERE a.name LIKE '%' + d.name + '%') = 1
AND type = 'g'
AND IS_SRVROLEMEMBER('sysadmin', a.name) = 0
AND default_database_name <> d.name
AND a.name NOT LIKE '%Diablo.Extract%'