Kill Blocked Process PID 52 without Reboot

Hello,
I need help :-))
We use an SQL 2000 Server.
in the Systemmanager one Prozess with PID is sleeping, no databese
context, and I can not cancel the Prozess.
When i try to update some Data, this Prozess ist Blocking all other.
How can i cancel this job without reboot the server.
Thanks
Is it SPID 2 (Lock Monitor), 3 (Lazy Writer) or 6?
What do you get back when you do DBCC Inputbuffer(<spid>)
What is your update statement that you are using?
Simon Worth
"matthias" <matthias.kunz.riedering@.gmx.net> wrote in message
news:O7q6zdiJFHA.2936@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I need help :-))
> We use an SQL 2000 Server.
> in the Systemmanager one Prozess with PID is sleeping, no databese
> context, and I can not cancel the Prozess.
> When i try to update some Data, this Prozess ist Blocking all other.
> How can i cancel this job without reboot the server.
> Thanks
|||Simon Worth schrieb:
> Is it SPID 2 (Lock Monitor), 3 (Lazy Writer) or 6?
> What do you get back when you do DBCC Inputbuffer(<spid>)
>
This is my Feedback DBCC
EXECUTE msdb.dbo.sp_help_alert @.order_by = N'severity ASC, message_id
ASC, database_name DESC'

> What is your update statement that you are using?
The Sttemaent is an stored procedure,
this stored Procedure was canceld from me, two seconds after Run :-((
And cince i canceld the Procedur, every following querry is blocked from
this SPID.
An reboot is not allowed. Is an high priority Server.
Anyone an Idea.
Matthias KUNZ

Kill Blocked Process PID 52 without Reboot

Hello,
I need help :-))
We use an SQL 2000 Server.
in the Systemmanager one Prozess with PID is sleeping, no databese
context, and I can not cancel the Prozess.
When i try to update some Data, this Prozess ist Blocking all other.
How can i cancel this job without reboot the server.
ThanksIs it SPID 2 (Lock Monitor), 3 (Lazy Writer) or 6?
What do you get back when you do DBCC Inputbuffer(<spid> )
What is your update statement that you are using?
Simon Worth
"matthias" <matthias.kunz.riedering@.gmx.net> wrote in message
news:O7q6zdiJFHA.2936@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I need help :-))
> We use an SQL 2000 Server.
> in the Systemmanager one Prozess with PID is sleeping, no databese
> context, and I can not cancel the Prozess.
> When i try to update some Data, this Prozess ist Blocking all other.
> How can i cancel this job without reboot the server.
> Thanks|||Simon Worth schrieb:
> Is it SPID 2 (Lock Monitor), 3 (Lazy Writer) or 6?
> What do you get back when you do DBCC Inputbuffer(<spid> )
>
This is my Feedback DBCC
EXECUTE msdb.dbo.sp_help_alert @.order_by = N'severity ASC, message_id
ASC, database_name DESC'

> What is your update statement that you are using?
The Sttemaent is an stored procedure,
this stored Procedure was canceld from me, two seconds after Run :-((
And cince i canceld the Procedur, every following querry is blocked from
this SPID.
An reboot is not allowed. Is an high priority Server.
Anyone an Idea.
Matthias KUNZ