Are there any constraints on the table that would prevent a parent record from being deleted if there is a child record?

It is much quicker to do SQL Passthrough and TRUNCATE TABLE then to do a delete all.

It is also possible that you do not have enough log space to handle the deletes. When you delete records the deletes are all logged and if you have a lot of records being deleted, it may fill the log. Check to see if you have restricted growth on the log table.

And again, Truncate Table does not log deleted records so it is rather final, but very quick.


>I have a remote view/Updatable to a SQL 7 table. I try to zap the record set,
>but that does nothing. I try to delete all in the remote view and
>get back a update conflict message. any Ideas? Thanks Eric.