September 6, 2013 at 8:54 am
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
September 6, 2013 at 3:43 pm
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.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy