Printable View
I am trying to delete 75000+ rows from a table. When I execute the query I get the following error: [Microsoft][ODBC Server Driver]Timeout Expired
The syntax for my delete statement is correct. Is there another way of completing such a massive process?
Set the ODBC query timeout value to something greater or 0 to wait forever.
or
Set the rowcount to a smaller value and delete multiple times.
or
if you are deleting all rows do a truncate table (beware of permission/backup issues)
------------
Grant at 6/7/00 11:21:35 AM
I am trying to delete 75000+ rows from a table. When I execute the query I get the following error: [Microsoft][ODBC Server Driver]Timeout Expired
The syntax for my delete statement is correct. Is there another way of completing such a massive process?