OK to KILL System SPID (Taskmanger)?

SPID6 (TaskManager, background) is causing some blocks. It
seems to have hung on a batch started several hours.
Is it safe to kill a system process? Will it simply get a
new process?
If no, any other suggestions? I can't stop & restart the
service for several hours.
Thnx
Steve
Steve Morgan
Peach Telecom SQL Server DBA
Please reply to the group, not to me!Steve - you can't kill system processes, so yes, you'd need to restart SQL
Server.
> SPID6 (TaskManager, background) is causing some blocks. It
> seems to have hung on a batch started several hours.
> Is it safe to kill a system process? Will it simply get a
> new process?
> If no, any other suggestions? I can't stop & restart the
> service for several hours.
> Thnx
> Steve
> Steve Morgan
> Peach Telecom SQL Server DBA
> Please reply to the group, not to me!
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq