Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-05 : 08:14:56
|
| Michael writes "I hope you can help. I've looked through about eventy-billion pounds of documentation and haven't been able to handle the following problem: How to cancel a submitted query by allowing the user to click on a web page button (or programmatically in general). I have a database of over 300 million records (and growing). The user starts a query (from a web front end) and then decides they don't want to wait. The query is left running which slows all other access. This annoys them (greatly). I would like to be able to somehow kill the query. I am running PHP/Apache/Linux on the front end. I can use c++ or perl or whatever is necessary to do the trick.Thanks for any help you can give me.ps: sql server is 2000 and running under windows 2000 advanced server." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-05 : 09:40:54
|
| KILL Spid?Don't know if that's a good idea though...Brett8-) |
 |
|
|
|
|
|
cancel query