Trigger that removes data older than one week

Apr 3 2013 3:27 PM
Hi,

I want to create trigger in SQL server that removes record which are older than one week.
I have date field in table, after inserting record in this table, it should automatically removed from table after one week. I want trigger to create trigger for that.
So help me how to create such trigger that fires after some time interval.

Thanks.

Answers (2)