Hi Mark
Essentially PACK is just copying all non-deleted records to a new table. Therefore instead of PACK you could just use COPY TO ... FOR !Deleted() and showprogress().... and then rename the target file and delete the original file when finished.
Jos
>
>Is there any way to do something similar with the PACK command. It does not support the for clause, but there are times when I need to pack large files and it would be nice to let the user know that something is actually happening.
>
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.