Software

Ask something
Discussion Locked

ODBC SQL Server Driver Timeout expired

0 helpful
4 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I run a query from the SQL Server Enterprise Manager, I get the above message as shown in the Title of Question.

What I need to set to prevent this from happening?

4 replies

by soede

I get the same error message in SQL server 2000 Enterprise Manager when deleting many rows. (20000 +) from one single table.

by quahsays

1. the SQL query statement may be complex, and it is taking longer time to get the result.
2. maybe the indexing on the tables are corrupted, or non-existent.
3. the server is not powerful enough, too little RAM, too little hard disk space.
4. network problem.

by paulkayengheng

These are the things, I also know. What I am looking for is more details technical aspects to overcome this problem of my.

This discussion is closed to new replies.