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 |
rama108
Posting Yak Master
115 Posts |
Posted - 2013-03-07 : 10:22:39
|
How to kill a running process in 2008?Thanks. |
|
rama108
Posting Yak Master
115 Posts |
Posted - 2013-03-07 : 10:29:54
|
Forgot to mention the details. I was running a stored proc which was taking long time, so I cancelled the query couple of hours ago. It is still showing "Executing...". Tried to KILL the SPID, but not working.Thanks. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-03-07 : 10:36:03
|
If it was in the middle of a transaction, partial changes will need to be rolled back - that may be the reason. Give it some time. |
|
|
rama108
Posting Yak Master
115 Posts |
Posted - 2013-03-07 : 10:58:50
|
thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|