> I did some searching but couldn't find an answer to help me discover
> which of the Linked Servers and/or Remote Servers on our instances are
> being used.  I wish I could delete them and wait for users to scream,
> but that idea got vetoed.  I would think it might be possible to
> determine this via Profiler or some other tool.  It would be very
> helpful to know specifically which Linked Server or Remote Server was
> used by programs, as we have some duplicates pointing to the same
> instance.
>
> Ideally I'd like to know also if the Remote Server is being used as a
> sender or receiver, as I believe they have to be set up on both
> instances to communicate, unlike Linked Servers - but I'm not certain
> that is how it works.
>
> I'm using SQL Server 2000, service pack 3.  Thanks for any ideas,
> templates, or code you might provide.