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