SQL Server Performance Forum – Threads Archive

rollback question

I have a process a user killed and it leaves "KILLEDROLLBACK" in the cmd column after an sp_who. When I use KILL &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess_id&gt; WITH STATUSONLY It tells me its 100% rolled back.<br /><br />What should I do with this process as it appears to be orphaned ?<br />Should I be running the cmd KILL &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess_id&gt; WITH STATUSONLY on aan already killed process to check it’s status ?<br /><br />Thanks all

---

Kindly do not post multiple (duplicate) posts, refer to thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2407 thread. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>