sys.server_principals (Transact-SQL)

Contains a row for every server-level principal.

Column name	Data type	Description
name	sysname	Name of the principal. Is unique within a server.
principal_id	int	ID number of the Principal. Is unique within a server.
sid	varbinary(85)	SID (Security-IDentifier) of the principal. If Windows principal, then it matches Windows SID.
type	char(1)	Principal type: S = SQL login U = Windows login G = Windows group R = Server role C = Login mapped to a certificate K = Login mapped to an asymmetric key
type_desc	nvarchar(60)	Description of the principal type: SQL_LOGIN WINDOWS_LOGIN WINDOWS_GROUP SERVER_ROLE CERTIFICATE_MAPPED_LOGIN ASYMMETRIC_KEY_MAPPED_LOGIN
is_disabled	int	1 = Login is disabled.
create_date	datetime	Time at which the principal was created.
modify_date	datetime	Time at which the principal definition was last modified.
default_database_name	sysname	Default database for this principal.
default_language_name	sysname	Default language for this principal.
credential_id	int	ID of a credential associated with this principal. If no credential is associated with this principal, credential_id will be NULL.

See Also