sending emails with a timed stored proced

I think you need to create an application, which you need to run at the server. Or, you create a page with a timer, which is sheduled to tick every 1 day or so. Then you can peform your code, which is basicly running trough some tests to see if an account is inactive.

I think it's better to do it with an application, whichs doesn't have to be running on the server. If you create an application (or windows service) which calls a web service (or bypasses a web server and calls the SQL server inmidiatly) it will work. Otherwise, not sure if it's possible, since ASP.NET pages are only executed on load (or I'm completely wrong)

Must be the voices speaking to you again  

But as noted, on shared hosting your options will be limited. Many companies with dedicated servers also lock down the sql mail functionality, some also lock the scheduler.

If it's important to you, get a $3-$4/month unix account that includes cron. Use lynx through cron to kick off a script and route the output to /dev/null.