Contains one row for each valid SQL Server user account. When SQL Server is installed initially, syslogins contains one entry, in which the name is sa, the suid is 1, and the password is NULL. It also contains an entry named probe with a NULL password. The login probe and the user probe exist for the two-phase commit process.
| Column | Datatype | Description |
|---|---|---|
| suid | smallint | Server user ID |
| status | smallint | Reserved |
| accdate | datetime | Reserved |
| totcpu | int | Reserved |
| totio | int | Reserved |
| spacelimit | int | Reserved |
| timelimit | int | Reserved |
| resultlimit | int | Reserved |
| dbname | varchar(30) | Name of user's default database when connection is established |
| name | varchar(30) | Login ID of user |
| password | varchar(30) | Encrypted password of user (may be NULL) |
| language | varchar(30) | User's default language (NULL for us_english) |
syslogins clustered, unique on suid
ncsyslogins nonclustered, unique on name
| sp_addalias | sp_changedbowner | sp_helpdb |
| sp_addlogin | sp_defaultdb | sp_helpuser |
| sp_addremotelogin | sp_defaultlanguage | sp_password |
| sp_adduser | sp_droplogin |