Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

take db out of single user mode

Status
Not open for further replies.
jayraykay

jayraykay

Programmer
Mar 10, 2004
22
US
Hello,

I have a database on sql2000 that went in to single user mode for some odd reason.

How do I take it out of singel user mode???

Thanks!
J
 
Sort by date Sort by votes
Try this in Query Analyzer ...

Code: 
exec sp_dboption 'MyDB', 'SINGLE USER', 'FALSE'

Change MyDB to the needed DB.

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
187
iambob
iambob
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
155
fredericofonseca
fredericofonseca
RRinTetons
  • Locked
  • Question
Sleuthing out job failure
Replies
3
Views
178
johnherman
johnherman
GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
160
GCL2007
GCL2007
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
103
intel233
intel233

Part and Inventory Search

Sponsor

Back
Top