• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • Last Modified:

Delphi 7 :: MS SQL 2005 - Timeout Expired

Dear Experts,

I have search the net for 2 days now in the hope for a solution that will solve my problem.
I managed to find several articles, including EE, explain a solution but none has worked for me.

My SQL query ran fine up until couple of days ago.
And as far as I can remember I did not made any major changes that could severly affect the query results...

But when running a given query (quite long query) I receives a "Timeout Expired" error.

I have changed settings in SQL Management Studio and also on all my components I have set the CommandTimeOut and ConncetionTimeOut properties to large numbers.

Please help URGENTLY....

Thanks.
0
Marius0188
Asked:
Marius0188
  • 2
1 Solution
 
SteveBayCommented:
Check the recovery model of the DB under Properties>Options. My guess is that it is "Full". Changing it to "Simple" may fix your problem. if this solves the problem then you have an indication of the source of the timeout issue. You will have to decide if "Simple" Recovery model is adequate or if it is necessary to increase you timeout values.
0
 
Marius0188Author Commented:
Ok I have forgot to add Index on one of the tables that I am refering to in my query.
This seem to do the job...
0
 
Marius0188Author Commented:
Will give the points anyway as you were only one to respond.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now