Post reply

How to forbid login user to SQL server

  • January 30, 2003 at 2:09 am

    #79995

    Is it possible to disable login user to SQL server when there are still other users logged? If it is, how can I do this?

    I have examples, when I have to forbid to login user to SQL server because of stopping SQL server. But I have to wait till all active users finished their jobs and they log off from SQL server.

  • January 30, 2003 at 5:03 am

    #447579

    One way is to pause the service. Existing users will stay connected until they finally stop whatever they are doing or you kill the spid. Anyone trying to connect once it's paused will get an error message (consider trapping for it in your apps!).

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

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

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