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 similar).
- Issue the command:
alter database db-name set SINGLE_USER
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 set MULTI_USER
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.