| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.syslogins (Transact-SQL) |
sys.syslogins (Transact-SQL) |
rwestMSFT |
randolphwest |
09/08/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains one row for each login account.
Important
[!INCLUDEssnoteCompView]
Applies to: [!INCLUDEssNoVersion] ( [!INCLUDEsql2008-md] through current version).
| Column name | Data type | Description |
|---|---|---|
| sid | varbinary(85) | Security identifier. |
| status | smallint | [!INCLUDEssInternalOnly] |
| createdate | datetime | Date the login was added. |
| updatedate | datetime | Date the login was updated. |
| accdate | datetime | [!INCLUDEssInternalOnly] |
| totcpu | int | [!INCLUDEssInternalOnly] |
| totio | int | [!INCLUDEssInternalOnly] |
| spacelimit | int | [!INCLUDEssInternalOnly] |
| timelimit | int | [!INCLUDEssInternalOnly] |
| resultlimit | int | [!INCLUDEssInternalOnly] |
| name | sysname | Login name of the user. |
| dbname | sysname | Name of the default database of the user when a connection is established. |
| password | nvarchar(128) | Returns NULL. |
| language | sysname | Default language of the user. |
| denylogin | int | 1 = Login is a [!INCLUDEmsCoName] Windows user or group and has been denied access. |
| hasaccess | int | 1 = Login has been granted access to the server. |
| isntname | int | 1 = Login is a Windows user or group. 0 = Login is a [!INCLUDEssNoVersion] login. |
| isntgroup | int | 1 = Login is a Windows group. |
| isntuser | int | 1 = Login is a Windows user. |
| sysadmin | int | 1 = Login is a member of the sysadmin server role. |
| securityadmin | int | 1 = Login is a member of the securityadmin server role. |
| serveradmin | int | 1 = Login is a member of the serveradmin fixed server role. |
| setupadmin | int | 1 = Login is a member of the setupadmin fixed server role. |
| processadmin | int | 1 = Login is a member of the processadmin fixed server role. |
| diskadmin | int | 1 = Login is a member of the diskadmin fixed server role. |
| dbcreator | int | 1 = Login is a member of the dbcreator fixed server role. |
| bulkadmin | int | 1 = Login is a member of the bulkadmin fixed server role. |
| loginname | nvarchar(128) | Login name of the user. Provided for backward compatibility. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)