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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-11-26 : 17:23:26
|
| Hi,What could be the way to change the mode of an instance being in a single-user mode to open (multi) mode?(When click on properties the error msg. is that db is already open and one user is connected).The only way I found was to reboot the machine, and get access for change in properties.Thx,Dobby |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-26 : 17:45:19
|
| Have a look in sysprocesses to see who the user is and get rid of them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
The Enigma
Posting Yak Master
179 Posts |
Posted - 2003-11-26 : 17:52:17
|
| Elaborating on nr :use sp_who2 .. and killAttitude is everything{The Enigma} |
|
|
|
|
|
|
User mode