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 derfloh 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
Joined
Mar 10, 2004
Messages
22
Location
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 Question
take a database from system databse place
Replies
2
Views
814
iambob
iambob
DougNaf
  • Locked
  • Question Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
670
fredericofonseca
fredericofonseca
RRinTetons
  • Locked
  • Question Question
Sleuthing out job failure
Replies
3
Views
718
johnherman
johnherman
GCL2007
  • Locked
  • Question Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
607
GCL2007
GCL2007
intel233
  • Locked
  • Question Question
Backup/Restore DB from SQL issues
Replies
2
Views
469
intel233
intel233

Part and Inventory Search

Sponsor

Back
Top