Re: [Emerald] Trimming call records.

Dale E. Reed Jr. ( (no email) )
Wed, 17 Feb 1999 16:13:04 -0800

Billy Huddleston wrote:
>
> Every time I go to trim the call records It bombs and says that the
> syslog file is full. I've checked it and my log file is 50 megs. What do I
> need to do to get it so I can Trim these records without any problems?

Trim fewer at a time. First, find the oldest record:

Select min(CallDate) from Calls

Now start from there going a day at a time:

Delete From Calls
Where CallDate < 'x/x/x/'

and then incrementing by one day each time. You might be able to get
away from weeks or months at a time, but it depends on how many
records you have in your Calls table.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html