Re: Error with Linked Servers

It's nothing to do with the query or the size of data. the problem is that
the linked server cannot be accessed until a reboot is done.

"Uri Dimant" wrote:

Well, is it large set data you want to return?

exec sp_serveroption 'servername','data access','true'



"MikeD" <MikeD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6EA13818-E61B-49E7-B6E0-35F581ADAF0F@xxxxxxxxxxxxxxxx
No - it's an openquery so it's :
SELECT * FROM OPENQUERY[linked_server_name], 'Select * from table_name'

But the problem isn't so much in the query it's the fact that when you
select the linked server the system hangs with no error message and the
only
way we have of resolving the issue is a server reboot

"Uri Dimant" wrote:

MikeD
Do you run the query in this way?
SELECT <> FROM Server.dbname.dbo.table




"MikeD" <MikeD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C11B49F-D1BF-48C2-9ECC-2470666F9691@xxxxxxxxxxxxxxxx
I can ping the server that sql is on if that's what you mean. I can see
and
create linked servers but cannot query them - see below.

"Uri Dimant" wrote:

MikeD
Do you have ping to linked server?

"MikeD" <MikeD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACBEC816-1EE1-46E8-9535-8E52BB7C502A@xxxxxxxxxxxxxxxx
From time to time the linked servers we have set up cannot be
accessed.
When
I click on the tables node under the linked server within enterprise
manager
the session hangs and no error message is displayed. When querying
the
data
via an openquery no error is thrown, the query simply runs until
manually
aborted.

I've created a linked server OK but immediately cannot open it. The
only
way
around this problem we have is a reboot of the server. Does anyone
know
how
to resolve this problem and also what would cause this.

Thanks

Mike









.

Relevant Pages

  • Re: SQL linked server with ODBC
    ... and then run the query. ... I am having trouble extracting data from a Navision ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
    (microsoft.public.sqlserver.odbc)
  • Temp table from text file connected via Linked Server
    ... I have a text file as a table in a linked server. ... statement to query the file, changing the name of the file. ... SELECT TextFile.* ... DECLARE @strFileName varchar ...
    (microsoft.public.sqlserver.programming)
  • RE: sp_runwebtask remote access error
    ... Did you find out if there was a bug for this issue? ... >and that prevents a linked server query from being called ... >Vikrant Dalwale ...
    (microsoft.public.sqlserver.security)
  • Re: Error with Linked Servers
    ... is it large set data you want to return? ... But the problem isn't so much in the query it's the fact that when you ... select the linked server the system hangs with no error message and the ... the session hangs and no error message is displayed. ...
    (microsoft.public.sqlserver.security)
  • Re: problem with Execute SQL Task
    ... I found out that the problem for the failure is due to a linked server query ... i did in my batch query. ... If this DTS package is run manually it works but when i schedule it to run ...
    (microsoft.public.sqlserver.dts)