Re: [Emerald] TRUNCATE TABLE of old RadLogs

Dale E. Reed Jr. ( (no email) )
Fri, 07 Apr 2000 15:52:06 -0700

NCKCN wrote:
>
> Can you use the TRUNCATE TABLE SQL statement to get rid of all the old
> RadLogs that has accumulated without hurting anything? This info keeps
> piling up and is pretty much useless after one day.

Here is a quick query that you could schedule to do it nightly:

DECLARE @dd datetime
Select @dd=DateAdd(Day, (0-7), GetDate())
Delete From RadLogs Where LogDate < @dd

-- 

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

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart