--This should do the trick if I understand what you're asking for:
SELECT PRIN.[name]
FROM sys.[server_permissions] PER
INNER JOIN sys.[server_principals] PRIN
ON PER.[grantee_principal_id] = PRIN.[principal_id]
WHERE PER.[permission_name] = 'CONNECT SQL'
AND (PER.[state] = 'G' OR PER.[state] = 'W')
ORDER BY PRIN.[name]
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford