Results 1 to 2 of 2

Thread: Disconnect Users

  1. #1
    Hugo Guest

    Disconnect Users

    Please help me

    I need to disconnect to all user in one step, because I disconnect them one by one.

    Does somebody knows how do it?.

    thanks for your help

  2. #2
    patrick Guest

    Disconnect Users (reply)

    Check in the sql scripts area for sp_axeusers, or write your own sql code to get the users out of sysprocesses put them in a forward only cursor and then execute the kill statement, or stop and restart the sql server service


    ------------
    Hugo at 5/29/01 6:38:01 PM

    Please help me

    I need to disconnect to all user in one step, because I disconnect them one by one.

    Does somebody knows how do it?.

    thanks for your help

Posting Permissions

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