Post reply

Profiling Linked Server Query

  • September 6, 2013 at 8:54 am

    #276951

    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

    #1648261

    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