This project is read-only.

proc_CleanExpiredData

Jan 22, 2009 at 7:04 PM
Just wanted an opinion about how to use proc_CleanExpiredData, I don't have access to the SQL Server Agent, so I created an On Insert trigger that runs proc_CleanExpiredData. Is there any better way of doing that?

It happends sometimes that the memcached provider timesout on the sql server, and I can't run a query on tblSessions until I stop the IIS. I'm wondering if the trigger may be reason for this?
Jan 23, 2009 at 2:09 AM
One suggestion would be to use a power shell script scheduled with Task Scheduler.
Consider using the new sqlps powershell that comes with SQL Server 2008 Express Management Studio to call the stored procedure.
http://msdn.microsoft.com/en-us/library/cc280450.aspx