There isn't really an automated way, unless you wanted to use
SQL Executive to cron a command.
I would check your database options (double click it in
SQLEW) and on the options tab, check Truncate on checkpoint.
That should keep the log low. We really have to dump the log
with that option set.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com