rpalnik -> Purging SQL Databases (10.Mar.2006 3:56:32 PM)
|
I've changed over to SQL for logging and noticed that there is no automatic procedure to purge the logs. After some experimenting, I found that running a query like this would delete records: use isa go delete from webproxylog where logdate = '3/4/2006' go Since I don't know any SQL, I'm a little stumped on how I would turn this into a stored procedure that would run everyday and let me delete records equal to (todays date) - (some number, maybe 7 or 10 days). Any pointers on where to start?
|
|
|
|