This topic has not yet been rated - Rate this topic

sysoledbusers (Transact-SQL)

SQL Server 2005

Important:
This SQL Server 2000 system table is included in SQL Server 2005 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions