Re: Purging History

Dale E. Reed Jr. ( (no email) )
Fri, 12 Dec 1997 09:31:34 -0800

Billy Huddleston wrote:
>
> My dialup history logs are getting full.. And I'm not using call
> consolidation. I wish to remove these records up to a certain date, how can
> this be done without causing problems and downtime with my users
> authenticating?

use somthine like:

Delete From Calls Where CallDate < '8/1/97'

And slowly increment the date by 10 days at a time.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com