How to automatically delete records in sql server after a certain amount of time

I have set up temporary user accounts on my sql database where the user names, passwords and date added of my websites users are stored. I was initially going to have these records delete programmatically but now im wondering if sql server 2008 has a built in function that allows records to be auto-deleted after … Read more