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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-02-26 : 09:09:47
|
Biplab De writes "Hey,I've an win2k server with SQL Server 7. I've an table with more than 100 000 records. My problem is when i try 2 execute queary it's showing "Microsoft OLE DB Provider for ODBC Drivers error '80040e31' >[Microsoft][ODBC SQL Server Driver]Timeout expired " error frequently.My question is how 2 solve this problem ? Is there any tricks or tips 2 avoid this error? regards Biplab De." |
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-26 : 10:00:16
|
Goto enterprise manager ,click on tools and then select options,Click on Advanced tab there you will find time out property set it to a higher value or 0 for unlimited value.HTH-------------------------------------------------------------- |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-02-26 : 10:36:05
|
Also look at optimising your query. Have a look at the following link:http://sqlteam.com/FilterTopics.asp?TopicID=103Most likly you need to add some indexes on your table.Indexes (the RIGHT indexes) can make your queries orders of magnititue faster than they are right now.Michaelmichaelp@televox.com |
|
|
|
|
|