March 18, 2008 at 7:57 am
I am running an SP from the front end and i want to terminate it... this is because of the locks on the tables. the sp is deleting data from some of the tables and since some another job is running, this is not getting completed at all and hence, i want to terminate it. Is there any way???
March 18, 2008 at 8:03 am
get the SPID of the process which is running stored procedure and kill the spid.
contact me at bmlakhani@yahoo.com if its urgent
March 19, 2008 at 3:06 am
Of course. SSMS can do it. DBLib supports it, OLEDB supports it, so it all depends on your knowledge on your front end, if you want to do it from your front end.
Otherwise read BOL on "sp_who" and "kill" commands.
March 19, 2008 at 3:28 am
the problem was there was no access for me and the DBA was out of office... i didnt have the permissions 🙁 so. i posted the topic...
anyways, somhow it got killed 🙂
Thanks for the responses anyways 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply