Undocumented SQL Server 7.0 System Tables
|
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.
No comments yet... Be the first to leave a reply!