killing your own running query

liunx

Guest
Hi all, I have a database custom search screen which clients do big searchs that can take up to 20 mins or so.

Here is the problem
If they notice it was wrong they should be able to cancel what they are running and change parameters of the query
I need a way to be able to cancel running query. but really sure how to do it. I cant see any easy way to do this is ther any one can help . tyI didn't do any tests. Just thinking. Did you try using threads and killing them?I didn't do any tests. Just thinking. Did you try using threads and killing them?
i guess when you say threads you mean the sql kill code
i did try to use kill spid thing with another connection (using 'sa' as user for theconnection) but it didnt work, or i couldnt do it, it wasn't like killing it from query analyzer or enterprise manager,
So not really sure what i did wrong i still need a way to get over this please help?
 
Back
Top