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. |
]]>