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!

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

can't get out of single user mode 1

Status
Not open for further replies.

soozle

IS-IT--Management
Jun 5, 2001
69
I'm having a bad day and can't think straight wth 2 servers down. I've just had to reinstall SQL server 6.5 on an NT4 server and it keeps starting up in single user mode after stopping and restarting the Server and Executive services.
I know I'm probably missing something obvious ..please help

soozle
 
This work on 7 and 2k, hope its the same on 6.5

sp_dboption 'databasename','single user','false'

Matt

Brighton, UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top