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

Query sys.server_principals

   <source lang="sql">

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