Post reply

Stopping the SP

  • March 18, 2008 at 7:57 am

    #121158

    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

    #790836

    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

    #791326

    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

    #791334

    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