[zero55]

примерно так.

создаете задание для SQL агента

DECLARE @DELETEDATE AS VARCHAR(255)
DECLARE @CURRENT AS DATETIME
SELECT @CURRENT = GETDATE()
SELECT @DELETEDATE = CAST(DATEPART(mm,@CURRENT) AS VARCHAR(2)) + '-' + CAST(DATEPART(dd,@CURRENT) AS VARCHAR(2)) + '-' + CAST(DATEPART(yy,@CURRENT) AS VARCHAR(4))

SELECT @DELETEDATE = DATEADD(dd, -45,@DELETEDATE)

DELETE FROM FirewallLog WHERE logtime < @DELETEDATE