Richard Teachout - My technobabble Blog - MSSQL: Single User Mode on Database

KeywordsPhrase

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.

MSSQL: Single User Mode on Database

Dec28

Written by:R Teachout
12/28/2006 1:07 PM

EXEC sp_dboption 'db_name, 'single user', 'FALSE'

EXEC sp_dboption 'db_name, 'single user', 'TRUE'
(to set as single user)

EXEC sp_dboption 'db_name, 'single user', 'FALSE'
(to set as multi user)

Location: Blogs

Tags:

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel

I do not fear computers. I fear the lack of them.
-Isaac Asimov