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
 Import/Export (DTS) and Replication (2000)
 Timeout & Table maximum

Author  Topic 

JNotenboom
Starting Member

27 Posts

Posted - 2001-11-16 : 04:00:52
Hi guys,
We have a big problem:
We are inserting (a lot of) data in SQL Server 2000. this is done via a delphi program which enters records just by plain old SQL: 'insert ..blabla..'. At a given moment, SQL Server generates a timeout. We do not know where it comes from.
We have one table which contains 4.7 mln records at the moment of the timeout and if we try to insert (simple by hand) another record, we receive again timeout.
Does anyone know what can be the problem? Is it a limitation of SQL Server? How many data can be in a table?
b. regards

   

- Advertisement -