You can either do a consolidation, delete the older data, or truncate
the table. All will greatly affect your SQL Server during the operation
(except maybe the truncate).
I explained the consolidation in my previous post. If You wan to
do one of the others, let me know.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com