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