sysxlogins |
Contains each Windows NT account or group name and each SQL Server login name. This table is stored in the master database.
Column name |
Data type |
Description |
srvid |
smallint, nullable |
Server ID. |
sid |
varbinary(85), nullable |
Security identifier. |
xstatus |
smallint |
For internal use only. |
xdate1 |
datetime |
Date the login was added. |
xdate2 |
datetime |
Date the login was updated. |
name |
sysname, nullable |
Login name. |
password |
varbinary(256), nullable |
Password of the user (may be NULL). |
dbid |
smallint |
ID of the database. |
language |
sysname, nullable |
User’s default language. |
isrpcinmap |
smallint, nullable |
For internal use only. |
ishqoutmap |
smallint, nullable |
For internal use only. |
selfoutmap |
smallint, nullable |
For internal use only. |
Published with the explicit written permission of the author. Copyrighted by the author.
]]>