Post reply

Clearing connections in SQL 7

  • December 31, 2002 at 3:52 pm

    #64621

    I know in SQL 2000 there is a way in the enterprise manager to clear connections. Is there a similar way in SQL 7.0 to clear these connections? I do not want to have to restart a server, but I can't detach when there are active connections.

    Any suggestions would be appreciated.

    Thanks and Happy New Year.

    Neil

  • December 31, 2002 at 4:15 pm

    #445391

    Absolutely.

    Kill(spid)

    of course, replace the spid with the process id of the connection you want to kill. And although EM is nice, I use QA to do it in either.

    There are some really nice procs in the scripts section of this site that allow killing all processes and so forth as well. You should check them out.

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

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