Jan 22, 2009 at 6: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 1: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.