I cannot Kill an SPID in SQL server 2000, what could be the problem? Sp_who shows KILLED/ROLLBACK i n cmd column. Pl helpHi,
As soon you kill a SPID , that process id will be marked for kill, but SQL
server will release the SPID only after rolling back
all the transactions it did. A long rollback will happen if you did a Batch
insert / Update / Delete.
Thanks
Hari
MCDBA
"Brijesh" <Brijesh@.discussions.microsoft.com> wrote in message
news:99556BBB-380E-484D-8818-165571942A82@.microsoft.com...
> I cannot Kill an SPID in SQL server 2000, what could be the problem?
Sp_who shows KILLED/ROLLBACK i n cmd column. Pl help|||Hi
Look at Task Manager for the process. Try END Process and see if it is
disappeared.
"Brijesh" <Brijesh@.discussions.microsoft.com> wrote in message
news:99556BBB-380E-484D-8818-165571942A82@.microsoft.com...
> I cannot Kill an SPID in SQL server 2000, what could be the problem?
Sp_who shows KILLED/ROLLBACK i n cmd column. Pl help|||What ever that SPID was doing is being rolled back... If you look at the
CPU or IO activity it is probably still chugging away.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23qITre7dEHA.1048@.tk2msftngp13.phx.gbl...
> Hi
> Look at Task Manager for the process. Try END Process and see if it is
> disappeared.
>
> "Brijesh" <Brijesh@.discussions.microsoft.com> wrote in message
> news:99556BBB-380E-484D-8818-165571942A82@.microsoft.com...
> > I cannot Kill an SPID in SQL server 2000, what could be the problem?
> Sp_who shows KILLED/ROLLBACK i n cmd column. Pl help
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment