Mega Code Archive

 
Categories / MSSQL Tutorial / System Tables Views
 

Query sys server_principals

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