This is kinda a cross-messageboard question, but I&#039;ll post it here cuz, well, this board gets more traffic. heh<BR><BR>When a user clicks the "Stop" button on his/her browser while running a report, the web server stops serving the page. That&#039;s all well and good, but I&#039;ve noticed that in SQL Server, the query (if it&#039;s still going) will keep running until it&#039;s finally finished. In other words, SQL doesn&#039;t know when the user clicks the "Stop" button.<BR><BR>Obviously, the server is using resources to run a cancelled query that could be used elsewhere. What I was wondering is if anyone knew a way to communicate to SQL Server that the query has been cancelled through an ASP page?