Mike’s Dump

June 18, 2005

Set database to single user mode (SQL Server/MSDE)

Filed under: Uncategorized — mikesdump @ 6:56 am

For example, to set pubs database to a single user mode, you can use the following statement:
EXEC sp_dboption ‘pubs’, ‘single user’, ‘TRUE’
The database has to be in single user mode to try and repair it.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: