Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sysoledbusers (Transact-SQL)

ms190496.note(en-US,SQL.90).gifImportant:
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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.