Stopping server side script after execution.

Problem: I have a few reports that grabs +- 27 000 records from a database, does a few calculations and queries on them, and then writes the results to a text file.

As you can imagine, this does take a while (half an hour if the server isn't busy) and hammers the servers resources.

I sometimes realise (after I've started the page) that I made an error in my code, or that another report is more important at the moment. The only way to stop the page if something like this happens, is to bounce the server (even closing my browser doesn't work) - which won't make me very popular

Is it possible (at all) to stop the execution of the page after it has been started? (I know that ASP is executed on the server, and only the results are sent through, but doesn't it have some sort of event handling?)

Any idees would be welcome. (even "it's not possible", then I can stop worrying abt it )

Not that I know of... the only way to do this would be to stop/restart the process. IISRESET in other words. If someone knows how to find an individual server process and kill it, I'd sure like to know. There is another alternative, however. You can kill the SQL job and that will halt the page. If you're using MS SQL Server, just look in Enterprise Manager for your running job. If there are so many jobs that it's hard to locate, then I suggest naming your connection so it's easy to find.
-Dave

Thanks, I'll try that (Yes, I do use MS SQL server). I hope that someone won't kill me if I accidently stop their job