Re: Error with Linked Servers

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)