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