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 |
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2013-04-08 : 07:39:08
|
I am getiing the below error while accessing any table of a database( Say database name is ABC)"Database 'ABC' is already open and can only have one user at a time."Please help.kalyan Ashis Dey |
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-04-08 : 07:43:06
|
Looks like the database is in single user mode.check with your DBA.mohammad.javeed.ahmed@gmail.com |
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2013-04-08 : 07:56:39
|
Yes you are right.it is in Single User mode. Could you please tell how can i remove this single user mode and make it multi user?kalyan Ashis Dey |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-04-08 : 08:01:48
|
ALTER DATABASE 'XXX' SET MULTI_USERmohammad.javeed.ahmed@gmail.com |
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2013-04-08 : 08:12:25
|
getiing the below error message :Msg 5064, Level 16, State 1, Line 1Changes to the state or options of database 'XXX' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.Msg 5069, Level 16, State 1, Line 1ALTER DATABASE statement failed.kalyan Ashis Dey |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-04-08 : 08:17:25
|
check the user currently conected and he can change the database to multi user.mohammad.javeed.ahmed@gmail.com |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-04-16 : 00:12:48
|
First Run SP_Who and see who is connected to the database when the database is in single user mode. Because , to set it back to Multi user mode it need exclusive lock on the DB which is already in single user mode and used by some other process. For more information, please check this discussion:http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/6fb2bb4b-46b7-4a5b-a3de-36a76b192472 |
|
|
|
|
|