create procedure sys.sp_MSIfExistsRemoteLogin
@remotesrvname sysname,
@locallgname sysname,
@remotelgname sysname
AS
begin
if (@locallgname IS NULL)
begin
IF EXISTS (SELECT * FROM master.dbo.sysremotelogins srl, master.dbo.sysservers ss
WHERE UPPER(ss.srvname collate database_default ) = UPPER(@remotesrvname) AND
srl.remoteserverid = ss.srvid AND
(srl.remoteusername = @remotelgname OR
(srl.remoteusername IS NULL AND srl.sid = 0x2)))
return (1)
else
return (0)
end
if exists (SELECT * FROM master.dbo.sysremotelogins srl, master.dbo.sysservers ss
WHERE UPPER(ss.srvname collate database_default ) = UPPER(@remotesrvname) AND
srl.remoteserverid = ss.srvid AND
srl.remoteusername = @remotelgname AND
srl.sid = suser_sid(@locallgname, 0))
return (1)
else
return (0)
end