RE: Kill Statment wont kill a spid.
I came across a simm. situation as well. At that time, I issued a ALTER DATABASE <DBANME> SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE <DBANME> SET MULTI_USER WITH ROLLBACK IMMEDIATE It solved my problem at that time. see if that helps.
2004-04-02