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