Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-05-25 : 19:04:34
|
| Hi i am struck in sungle user mode.How do i come out?plz helpregards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 19:09:14
|
| You can use the ALTER DATABASE command. Check BOL for details.Tara Kizeraka tduggan |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 19:10:36
|
| Tarai am nt able to connect thru query analyzerRegards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 19:11:34
|
| What is in the single user mode? The master database or a user database?Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 19:15:20
|
| Reason: Server is in single user mode. Only one administrator can connect at this time.This is the message i am gettingRegards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 19:16:27
|
| Did you restore the master database?Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 19:18:28
|
| Nopewas just doing some r&d on my local machineand i put my machine itno single user mode..regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 19:20:41
|
| How did you put your machine into single user mode?Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 19:22:45
|
| net stop MSSQLServersqlservr -mregards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 19:25:53
|
| -m means to put it into single user mode. So you'll need to start it up without this switch. Check out "Using Startup Options" article in BOL.Tara Kizeraka tduggan |
|
|
|
|
|
|
Struck in single user mode