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>
<source lang="sql">
5> SELECT name, principal_id, type_desc 6> FROM sys.server_principals 7> WHERE LEFT(name, 4) <> "##MS" 8> GO</source>