Unable to Kill Process :dbcc inputbuffer

  • lenymendoza

    SSC Veteran

    Points: 274

    Hi,

    Trying to kill this process using kill 14 but does not

    work. dbcc inputbuffer(14) shows the following.

    How can I force to kill this process which has run a few

    days ago on NT4 using MSSQL 7.0?

    I am supposed to restore a database but it prompts me that the database is currently in used. I did check the processes currently running and it show that SPID 14 is runnable. This is the reason why Im trying to Kill the Process.

    Please advise. Thank you.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    There's no "following" that explains what you see.

    However likely if you can't kill the process, you'll need to restart SQL Server.

  • Gail Shaw

    SSC Guru

    Points: 1004424

    You can't kill system processes, and from the value of the spid, that's likely a system process.

    Why do you want to kill it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Lynn Pettis

    SSC Guru

    Points: 442118

    Almost a four year old thread.

  • Jeff Moden

    SSC Guru

    Points: 994284

    Lynn Pettis (4/7/2014)


    Almost a four year old thread.

    BWAAA-HAAAA!!! (Sorry... did that come out loud?) 😛

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply