Home Forums SQL Server 2005 Administering Changing Database In Single User Mode To Multi User RE: Changing Database In Single User Mode To Multi User

  • If you just want to be able to drop the database, use this:

    use master
    alter database RB_Data_Services_MSCRM set offline with rollback immediate

    That will kick everyone out of the database, and set it offline so that no users can connect to it.  Then you can use a drop database command to delete it.