sys-syslogins-transact-sql.md

title	sys.syslogins (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	syslogins_TSQL syslogins sys.syslogins sys.syslogins_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.syslogins compatibility view syslogins system table
ms.assetid	4cb34f17-a4bb-469f-a218-71f074e6308f
caps.latest.revision	41
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.syslogins (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Contains one row for each login account.

Important

[!INCLUDEssnoteCompView]

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] 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)