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.
Thanks
Can 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