Linked Server Hang up

My MS Access app links to an SQL Server 2000 db which includes a linked
server.
A pass through query like "select * from linkedtable" works fine. But
"select * from linkedtable where linkedtablekey=1" fails - ODBC timeout
error.
The same thing happens when I try the queries in Query Analyzer.
This error only occurs on the production computer - the queries work fine in
the test environment.
Thanks, in advance, for suggestions.
DT"David Taylor" <dreddog@.gmail.com> wrote in message
news:ekE%23ZPRoIHA.2292@.TK2MSFTNGP03.phx.gbl...
> My MS Access app links to an SQL Server 2000 db which includes a linked
> server.
> A pass through query like "select * from linkedtable" works fine. But
> "select * from linkedtable where linkedtablekey=1" fails - ODBC timeout
> error.
> The same thing happens when I try the queries in Query Analyzer.
> This error only occurs on the production computer - the queries work fine
> in the test environment.
> Thanks, in advance, for suggestions.
> DT
Hi David
You may want to use SQL Profiler to see exactly what SQL is being executed
on the server. If the where clause is being implemented on the client it may
be trying to return a large amount of data.
Have you checked that indexes, usage and statistics are up-to-date on the
production server?
John|||I would check and see if schema of the production and test servers are
identicall (indexes, triggers, constraints...). Also, if indexes are not
set up properly and there is much more data on production server, it could
be the cause for time out (large scan operation on source)
MC
"David Taylor" <dreddog@.gmail.com> wrote in message
news:ekE%23ZPRoIHA.2292@.TK2MSFTNGP03.phx.gbl...
> My MS Access app links to an SQL Server 2000 db which includes a linked
> server.
> A pass through query like "select * from linkedtable" works fine. But
> "select * from linkedtable where linkedtablekey=1" fails - ODBC timeout
> error.
> The same thing happens when I try the queries in Query Analyzer.
> This error only occurs on the production computer - the queries work fine
> in the test environment.
> Thanks, in advance, for suggestions.
> DT
>