>Do you have FK's in this table? It may be due to that. Can you do a
>
>DELETE FROM MyTable
This seems to be the problem. DELETE FROM does work on all three of my tables. I'd prefer the deletes not be logged in this case, but I'll live.
One of the tables actually did not contain a fk, but it was the parent of the other two tables. I see now the help mentions the issue with fk's. It's intuitive why a parent table would also not be allowed to be truncated, although it does not contain a fk. I guess this is why the help uses the wording "referenced by a foreign key," which at first glance I thought was poorly stated.
Thanks...
Del