Transact-SQL Reference
sysoledbusers
Contains one row for each user and password mapping for the specified linked server. This table is stored in the master database.
| Column name | Data type | Description |
|---|---|---|
| rmtsrvid | smallint | SID (security identification number) of the server. |
| rmtloginame | nvarchar(128) | Name of the remote login that loginsid maps to for linked rmtservid. |
| rmtpassword | nvarchar(128) | Encrypted password for the specified remote login in linked rmtsrvid. |
| loginsid | varbinary(85) | SID of the local login to be mapped. |
| status | smallint | If this value is 1, the mapping should use the user's own credentials. |
| changedate | datetime | Date mapping information was last changed. |