The start records can be removed safely. We are testing a new option of
RadiusNT that will manually update the calls online for start records,
rather than putting the start records in the DB. This will save lots
of DB time/space. :)
For Now, use this to delete start records. One thing you should note.
large Databases, do not just simply delete all the start records, you'll
fill you log. I like to do it in half/month increments.
Delete From Calls
Where AcctStatusType = 1
AND CallDate < '11/1/96'
and uping the date by either a month or 15 days. Your mileage will vary
on this, though.
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com