title: How to automatically delete records in sql server after a certain amount of time
body: <p>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.</p>
  
  <p>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 lets say one day. </p>
  
  <p>This would resolve the issue of a user being able to stay logged into the system after their temporary account is closed</p>
  
  <p>thanks</p>