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. |