SQLTeam.com | Weblogs | Forums

Audit Linked-Server Querys / Users


#1

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 :wink:


#2

You may try using SQL Server Profiler Trace to find.