I have a requirement to delete data from a table in my SQL database automatically, that is, with no user interaction required. Is this possible? The format of my table is relatively straight forward. It is basically an event log of certain actions performed by administrators with an event column, a user id coulmn , and a timestamp column. I would like to have the database remove events older than a week at periodic intervals. Once a day for example. How can I accomplish this?
I am running my App on a shared server so I cannot install my own application and so forth. Is this a windows forms thing or can I do it with ASP.Net?
Thanks for your help
View Complete Post