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)  Timeout error when trying to delete records

Author  Topic  rewry Starting Member 6 Posts Posted - 2001-04-30 : 10:34:15 I have a table with about 5 Million records in it. I'd like to remove about 2 Million records from the table. Doing a straight delete query (DELETE FROM Table WHERE [Date] = '12/22/00') I get the error "[Microsoft][ODBC SQL Server Driver]Timeout expired". The server is SQL Server 2000. I'm working in Enterprise Manager. The field that I'm using in the WHERE clause is indexed. I have the "Query time-out" property for the server set to 0. I've been told that the only way to get rid of the records would be to export only the records I want to keep using DTS and then importing them back in. Is this really the only way I can get this task done? Thanks in advance.