Results 1 to 4 of 4

Thread: Kill Processes

  1. #1
    Join Date
    Apr 2004
    Posts
    73

    Unanswered: Kill Processes

    Can you kill processes in SQL Server 2K without stopping SQL Server and restarting it? I am using sp_who2 to get a list of active users and I see some accounts that are logged off but still showing up and I am trying to find a way to Kill these accounts and the processes they are doing.

  2. #2
    Join Date
    Apr 2004
    Posts
    101
    you can use
    1) KILL 53(spid)
    Or
    Enterprise Manager-->Management-->current Activity-->Process Info
    you can pick specific spid and kill it from here..
    SS

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What do you mean logged off?

    Sleeping?

    How many connections are we talking about?

    Do you see the Login?

    Can you NET SEND them a message?

    Better off to leave them alone...It takes resources to reestablish them...

    Anyway you'll love this...

    It's KILL <spid>
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Apr 2004
    Posts
    73
    Do I just do this in the Query Analyer?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •