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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Query Timeout Problem

Author  Topic 

rashmi
Starting Member

3 Posts

Posted - 2002-07-19 : 01:18:57
Hi,
The sql server is running on windows 2000(with 1GB RAM and 100GB Hard Disk).
Query Timeout has been set to 0(which means unlimited) but still when a process tries to insert data in the database it is not able to do and is showing query timeout.
I am facing this problem for many days.The database contains data for around 2 months and data gets inserted into the database after every 5 mins through a backend process.

Please help me in this regard.

Regards
Rashmi Dwivedi

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-07-19 : 02:26:44
Hi Rashmi,
Will you send the Table structure, in which you are trying to insert the data (With Indices).


---------------------------
Sandesh - The Messanger
Go to Top of Page
   

- Advertisement -