Kill Prozess PID 52 without Reboot the Server

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.
ThanksCan you run DBCC INPUTBUFFER(52) on the server, and show us the output?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<matthias.kunz.riedering@.gmx.net> wrote in message
news:eL9iq9hJFHA.3356@.TK2MSFTNGP12.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|||Narayana Vyas Kondreddi schrieb:
> Can you run DBCC INPUTBUFFER(52) on the server, and show us the output?
Hello an good morning :-)
thies is the Output of the DBCC Inputbuffer
Output:
EXECUTE msdb.dbo.sp_help_alert @.order_by = N'severity ASC, message_id
ASC, database_name DESC'
Thanks
Matthias Kunz