Query sys.server_principals : sys.server_principals « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.server_principals
5> SELECT name, principal_id, type_desc
6> FROM sys.server_principals
7> WHERE LEFT(name, 4) <> '##MS'
8> GO
27.12.sys.server_principals
27.12.1.Query sys.server_principals