SQL Server/T-SQL Tutorial/System Tables Views/sys.server principals

Query sys.server_principals

5> SELECT name, principal_id, type_desc
6> FROM sys.server_principals
7> WHERE LEFT(name, 4) <> "##MS"
8> GO