Re: kill user connections

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/26/04

  • Next message: Hari: "Re: kill user connections" 
    Date: Thu, 25 Mar 2004 21:09:23 -0600

    Try BooksOnLine. Specifically you might want to look at sp_who and KILL
    commands. 

    --
Andrew J. Kelly  SQL MVP
"pk" <pk@> wrote in message news:e#XJeQtEEHA.3576@tk2msftngp13.phx.gbl...
> can someone point me to a good site / article on how to go abt checking
for
> current user connections and kill these connections,
> using Enterprise Mge & T-SQL.
>
> try searching Microsoft, didn't find what I am looking for.
>
>
> tks
>
>
  • Next message: Hari: "Re: kill user connections"

    Relevant Pages

    • kill user connections
      ... can someone point me to a good site / article on how to go abt checking for ... current user connections and kill these connections, ... using Enterprise Mge & T-SQL. ...
      (microsoft.public.sqlserver.server)
    • Re: Server Roles Process administrators
      ... You can give MS PSS a call and if it is ... Andrew J. Kelly SQL MVP ... I think is a bug in the tools but I need a confirmation ... If we use command Kill in query Analyser no problem. ...
      (microsoft.public.sqlserver.security)
    • Re: Minister warns of expanding obesity problem
      ... I discern that when folks write that they will put me in their kill ... Servant to the humblest person in the universe, ... Dr. Andrew B. Chung, MD/PhD ...
      (sci.med.cardiology)
    • Re: How to Become a Christian, Version 1.01
      ... I shouldn't kill anyone, but if I get some friends ... Servant to the humblest person in the universe, ... Dr. Andrew B. Chung, MD/PhD ...
      (sci.med)
    • Re: How to Become a Christian, Version 1.01
      ... I shouldn't kill anyone, but if I get some friends ... Servant to the humblest person in the universe, ... Dr. Andrew B. Chung, MD/PhD ...
      (sci.med.cardiology)