sys.sysoledbusers (Transact-SQL)
Important
|
|---|
|
This SQL Server 2000 system table is included in SQL Server as a view for backward compatibility only. We recommend that you use catalog views instead. |
Contains one row for each user and password mapping for the specified linked server. sysoledbusers is stored in the master database.
|
Column name |
Data type |
Description |
|---|---|---|
|
rmtsrvid |
smallint |
Security identification number (SID) of the server. |
|
rmtloginame |
nvarchar( 128) |
Name of the remote login that loginsid maps to for linked rmtservid. |
|
rmtpassword |
nvarchar( 128) |
Returns NULL. |
|
loginsid |
varbinary( 85) |
SID of the local login to be mapped. |
|
status |
smallint |
If 1, the mapping should use the credentials of the user. |
|
changedate |
datetime |
Date the mapping information was last changed. |
