syslogins

Contains one row for each login account.

Column name	Data type	Description
sid	varbinary(85)	Security identifier.
status	smallint	For internal use only.
createdate	datetime	Date the login was added.
updatedate	datetime	Date the login was updated.
accdate	datetime	For internal use only.
totcpu	int	For internal use only.
totio	int	For internal use only.
spacelimit	int	For internal use only.
timelimit	int	For internal use only.
resultlimit	int	For internal use only.
name	varchar(30)	Login ID of the user.
dbname	nvarchar(128)	Name of the user's default database when connection is established.
password	nvarchar(128)	Encrypted password of the user (may be NULL).
language	nvarchar(128)	User's default language.
denylogin	int	1, if login is a Microsoft® Windows NT® user or group and has been denied access.
hasaccess	int	1, if login has been granted access to the server.
isntname	int	1 if login is a Windows NT user or group; 0 if the login is a Microsoft SQL Server™ login.
isntgroup	int	1, if login is a Windows NT group.
isntuser	int	1, if login is a Windows NT user.
sysadmin	int	1, if login is a member of the sysadmin server role.
securityadmin	int	1, if login is a member of the securityadmin server role.
serveradmin	int	1, if login is a member of the serveradmin fixed server role.
setupadmin	int	1, if login is a member of the setupadmin fixed server role.
processadmin	int	1, if login is a member of the processadmin fixed server role.
diskadmin	int	1, if login is a member of the diskadmin fixed server role.
dbcreator	int	1, if login is a member of the dbcreator fixed server role.
loginname	nvarchar(128)	Actual name of the login, which may be different from the login name used by SQL Server.