Delete Query Timeout

[Grant]

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?

[n]

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?