Query: Timeout depending on number of rows retrieved

A

alex.vezeau

I have a query:
select * from projet where prcleunik between 70 and 110

Runs fine from all workstations and/or servers.

If I change the between statement to:
select * from projet where prcleunik between 30 and 110

It runs fine from all workstations and/or servers EXCEPT from our web
server.

Any answers on why a exact same query might return an error when
executed from one server in particular and not from all the others ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connection timeout 2
Query on SqlConnection of ADO.NET 2
SP in Typed Dataset Timeout vs Management Studio Good Performance 9
Bizarre slow query problem (again) 25
No Foreign Keys retrieved 8
command timeout - SQL 2005 express - critical customer down 4
TableAdapter and ROW_NUMBER problem 1
Long running stored procedure 2

Top