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:
- Connect to SQL Server using SQL Query Analyzer (or osql or
- Issue the command:
alter database db-name set
db-name" is the name of
the database to place in single user mode.
- 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
These notes have been tested against
SQL Server 2000 running under Windows XP.
About the author: Brian Cryer
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.