Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Czech republic

    Question Unanswered: How to prevent users from logging to DB during its "maintenance"

    I am really a DB admin beginner, so hopefully it'll be easy for you to answer my simple question:

    How can I temporarily prevent users (except "sa") from logging to database(s) or better to DB Server while there are applied scripts on them ?

    I have already tried TCP/IP port changing, hiding server, running a single user mode but the reult was very poor. Please note that "sa" has to be able to connect to DB Server from a third party application but other users not.

    Any idea and/or a known solution ?
    Thanx in advance for your hints

    BTW - MS SQL 2000 SP3a

  2. #2
    Join Date
    Feb 2004
    you could restrict the access to the database for a single user (sa) or members of db_owner (in em, right click the database, options) or temporarily drop the access rights of the users.

Posting Permissions

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