Contains one row for each login account.
|
Column name
|
Data type
|
Description
|
|---|
|
sid
|
varbinary(85)
|
Security identifier.
|
|
status
|
smallint
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
createdate
|
datetime
|
Date the login was added.
|
|
updatedate
|
datetime
|
Date the login was updated.
|
|
accdate
|
datetime
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
totcpu
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
totio
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
spacelimit
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
timelimit
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
resultlimit
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
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 Microsoft 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 SQL Server 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.
|