Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Linked server data access

0 views
Skip to first unread message

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

unread,
Nov 20, 2009, 11:37:02 AM11/20/09
to
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

Erland Sommarskog

unread,
Nov 20, 2009, 5:17:25 PM11/20/09
to
Alessandro D'Elicio (Alessandro D'Eli...@discussions.microsoft.com) writes:
> 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?

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?

"Your" SQL Server, what role does it play? Is this a company-wide SQL
Server? An application-specific SQL Server? I'm trying to understand
the context.


--
Erland Sommarskog, SQL Server MVP, esq...@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

0 new messages