sysremotelogins

Transact-SQL Reference

Transact-SQL Reference

sysremotelogins

Contains one row for each remote user allowed to call remote stored procedures on Microsoft® SQL Server™.

Column name Data type Description
remoteserverid smallint Remote server identification.
remoteusername nvarchar(128) User's login name on a remote server.
status smallint Bitmap of options.
sid varbinary(85) Microsoft Windows NT® user security ID.
changedate datetime Date and time the remote user was added.