Hi,
it is possible to create an audit, which records the queries to a Linked Server. We want to remove the Linked Server, and therefore find out which query or user the Linked Server uses.
Thanks
Regards Nicole
You may try using SQL Server Profiler Trace to find.