sys-syslogins-transact-sql.md

title	sys.syslogins (Transact-SQL)
description	sys.syslogins (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	09/08/2017
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	syslogins_TSQL syslogins sys.syslogins sys.syslogins_TSQL
helpviewer_keywords	sys.syslogins compatibility view syslogins system table
dev_langs	TSQL

sys.syslogins (Transact-SQL)

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

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)