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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-30 : 11:09:59
|
Ralph writes "Running SQL Server 2000, I have a table with several million records. I'd like to delete a million or so records from it, but each time I run a delete query (DELETE FROM Table WHERE Date = '1/1/00') I get the error "[Microsoft][ODBC SQL Server Driver]Timeout expired".
The field in the table that I'm using in the WHERE clause is indexed. As well the "Query time-out" server connection property is set to 0 (unlimited). I'm using Enterprise Manager to connect to the database.
I've been told that the only way I can get rid of my unwanted records would be to use DTS to export the table (without the unwanted records) and then bring them back in, which seems to be a big pain.
Am I stuck with the DTS solution or is there something else I can try?
Thank you in advance." |
|
|
|
|
|
Timeout error deleting records