How do you do a SQL Passthrough and Truncate Table?
I'm looking for specific code--I can't find it on UT or MS sites.
TIA,
Joy
>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.
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488