Re: [RadiusNT] Is there a trigger or something to automatically clear

Dale E. Reed Jr. ( (no email) )
Wed, 13 Oct 1999 12:41:48 -0700

Kelly Peterson wrote:
>
> Our calls table on our MS SQL 7 database grows very quickly. Since we
> don't use that data is there some way to have it automcatically cleared?

Use SQL Agent to schedule a nightly TSQL task like the below. Change
the
30 to whatever you want.

DECLARE @deldate as datetime

Select @deldate = DateAdd(Day, 0-30, GetDate)

Delete From Calls
Where CallDate < @deldate

-- 

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