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 |
|
pwcphoto
Yak Posting Veteran
69 Posts |
 Posted - 2007-10-13 : 19:08:31
|
| It appears that our database is stuck in single user mode. I cannot access the particular database via enterprise manager and the associated web site that uses it is down.I have listed the spid that are in use and tried to kill them and then set the databse to multi user mode but it still says that it is in use and set for single user mode.This is a shared sql server at a hosting company and they do not have a clue it seems other then rebooting which doesnt seem to do anything.For security reasons related to their other clients I cannot have direct access to the srver. Anyone have any suggestions that I can tell the weenie at the other end of the phone in order to see if we can get this thing back online? He has access to the enterprise manager at that end as SA however he cannot access our database either.Any help would be appreciated. Thanks,Phil-----------------------I used to be a rocket scientist. Now I'm just a space cadet... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 21:50:42
|
| Let them run sp_who2 and ensure there is no connection to your db, then uncheck single user in em. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-14 : 01:08:48
|
| How about getting someone to to run:ALTER DATABASE MyDatabaseName SET MULTI_USER WITH ROLLBACK IMMEDIATENot sure what permission level is required, you may be ale to do that yourself.Kristen |
|
|
|
|
|
|
Database stuck in single user mode