Failed to Kill a User Process - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Failed to Kill a User Process

Author

Topic

AndreaKo
Starting Member

2 Posts

Posted - 2010-03-23 : 22:11:27

I have a process with the following information, and i execute the kill process to kill this id, and it return me "Only user processes can be killed."

SPID:11
Status:BACKGROUND
Login:sa
HostName: .
BlkBy: .
DBName: SAFEMIG
Command:CHECKPOINT

Normally, all the session to login to this server, it should have a HostName which display our PC name, but this connection is with a dot, so not sure who is executing what process that have this connection.

I execute "dbcc inputbuffer(11)"
It return me"EventType= No Event, Parameters = 0 and EventInfo=Null"

Appreciate for any help\advice on this problem!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-23 : 23:22:34

You can't kill spids less than 50 as those are system spids. It's not a real user.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog