locked
kick off/disable users RRS feed

  • Question

  •  

    I am running a load and I would like to know how to kick off/disable users when I load and enable them after the load?
    Thursday, October 16, 2008 2:17 PM

Answers

  • You can set the database to Single User mode and then perform the load.

     

    ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

     

    Then enable Multi User again.

     

    ALTER DATABASE DatabaseName SET MULTI_USER

    Thursday, October 16, 2008 2:44 PM