sys.sysoledbusers (Transact-SQL)
SQL Server 2008 R2
 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. |
