Brian Cryer

Cry How to...

Set a single database into Single User Mode

To set a single database in a SQL Server 2000 database into single user mode:

  1. Connect to SQL Server using SQL Query Analyzer (or osql or similar).
  2. Issue the command:
        alter database db-name set SINGLE_USER
    where "db-name" is the name of the database to place in single user mode.

Note:

  • This cannot be used to place the databases MASTER, MSDB or TEMPDB in single user mode. For these you will need to start SQL Server 2000 in Single User Mode.
  • To set a database back into normal multi-user mode use, issue the command:
        alter database db-name set MULTI_USER

These notes have been tested against SQL Server 2000 running under Windows XP.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.