Linked server data access

Hello,
I have a linked server defined on my SQL server and I
I would like to monitoring all the query o store procedure that try to
access on this data becouse I would like to permit only one access per time
on that linked server. My indea is that only one query or stored procedure
can use the linked server in the same time, if there are one more query ore
store procedure that try to access there, it must wait untill the first one
finish the execution. Is possible to do it?
Thak you


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?mid=7f6f12e9-8e8c-4a93-b631-47cecae8e7d8&dg=microsoft.public.sqlserver.connect

Alessandro D'Elicio (Alessandro D'Elicio@discussions.microsoft.

Alessandro D'Elicio (Alessandro D'Elicio@) writes:

Maybe, but I would like to know a little more.

Which version of SQL Server are you using?

Is the linked server another SQL Server instance?

What exactly are you trying to achieve? That is, what is the rationale
for want to serialize access to the linked server?

Server? An application-specific SQL Server? I am trying to understand
the context.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx