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.

Pages: 1 2 3 4




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |