Timeout expired

[dirkg]

I have this really ennoying problem with my SQL Server database that I use as database for a network on the Internet (

http://www.it2.be):

usually it works fine but lately it starts to give the following error:

Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired

This error only happens when executing stored procedures that make updates or appends to the database, hence just retrieving information still works fine. The only thing that helps then is resetting te server. The problem is purely related to that particular database because updates in other databases on the same server still work fine.

Once I could solve it by setting the filesize to unlimited growth but now the problem is there again...

Do you have any idea what this can be and how I can solve it? You would really help me out if you can solve this one...

 

[ClaireHCM]

1.Is the table huge?
2.Any index created on that table?
3.Do you periodically maintain or rebuild the index?
4.Any unnecessary indexes created by SQL Server due to "Auto create statistics"?

 

[dirkg]

The thing is that when this problem occurs, I get a Timeout on every table which I try to update, even if it has only 10 records.
The largest table in the database has about 5000 records, all tables have at least a primary index.

 

[ClaireHCM]

That's not big at all.
Do you have connection limitation? Network problem? Sounds really weird, if you find out the issue and resolution, please let me know.