Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Profiling Linked Server Query Expand / Collapse
Author
Message
Posted Friday, September 6, 2013 8:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 9:02 AM
Points: 594, Visits: 1,591
Hi all

I was profiling a DB for queries against it but have noticed that when a table in the DB is accessed through a linked server this does not show in profiler. Can anyone advise on why this is or what events I need to select to ensure this is captured in future?

Thanks
Post #1492284
Posted Friday, September 6, 2013 3:43 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 789, Visits: 694
I'm not sure that I understand your question; it seems that you are leaving out some details. Are you tracing for auditing purposes?

Since tables on a linked server are outside the instance you are running Trace from, you will not be able to capture access to these tables. If the linked server is another SQL Server, you can run Trace on that server to capture access to objects on that server.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1492443
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse