CREATE PROCEDURE ELMAH_DELETE_OLDERRORS
AS
BEGIN
SET NOCOUNT ON;
DELETE FROM ELMAH_Error
--SELECT * FROM ELMAH_Error
where TimeUtc < dateadd(DAY,-7,getdate());
END
GO
AS
BEGIN
SET NOCOUNT ON;
DELETE FROM ELMAH_Error
--SELECT * FROM ELMAH_Error
where TimeUtc < dateadd(DAY,-7,getdate());
END
GO
No comments:
Post a Comment