syslogins

Transact-SQL Reference

Transact-SQL Reference

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.