Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwsjbs
Starting Member
17 Posts |
 Posted - 2010-01-29 : 19:46:26
|
| I'm running a query on a table that has 600,000+ rows and keep getting the following error message:[Microsoft][ODBC SQL Server Driver]Timeout expired.If I run the same query when the table has only 50,000 rows, it runs fine.I'm using MS SQL 2000.Can anyone tell me how to increase the Timeout time or offer another solution?Thank you,Richard Scott |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-30 : 01:15:09
|
| can you show the query? also it would be better if you try running this on query analyser with show plan option on and analyse costly steps. |
 |
|
|
rwsjbs
Starting Member
17 Posts |
Posted - 2010-01-30 : 16:13:17
|
| Visakh16,Thank you for your answer. I was trying to run this query in the SQL Server Enterprise Manager after opening up the table. When I switched to run this through Query Analyzer (your suggestion) it ran completely and did not time out.I sincerely appreciate your help.Thanks for solving my problem,Richard Scott |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-30 : 21:12:32
|
| Why are you using UI to open all rows? |
|
|
|
rwsjbs
Starting Member
17 Posts |
Posted - 2010-01-31 : 19:55:53
|
| Sodeep,I am fairly new to SQL and didn't realize that I should use Query Analyzer.Thanks,Richard |
|
|
|
|
|
|
Timeout expired - when running query on table