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 |
|
learntsql
524 Posts |
 Posted - 2009-10-29 : 07:19:54
|
| HiHow to change the report server database state from restricted to multiple;when i am trying to do getting following error.plz help.Msg 1222, Level 16, State 28, Line 1Lock request time out period exceeded.Msg 5069, Level 16, State 1, Line 1ALTER DATABASE statement failed. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-10-29 : 08:39:54
|
| In order to do this you need to kill all connections to the database first. If it's a one time deal you can do it using the management studio instead; right-click the database -> properties -> options -restricted access at the bottom.- Lumbagohttp://xkcd.com/327/ |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-10-29 : 10:34:25
|
This will disconnect all users.alter database [MyDatabase] set multi_user with rollback immediate CODO ERGO SUM |
|
|
|
learntsql
524 Posts |
Posted - 2009-10-30 : 00:29:45
|
| still i am getting error called"Lock request time out period exceeded."any more sugestions plz. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-10-30 : 10:25:41
|
| press CTRL + 1 and check who is on the database stopping the proccessbut i'd use either of the above suggestions |
|
|
|
learntsql
524 Posts |
Posted - 2009-10-31 : 00:50:02
|
| Thank you allit worked. |
|
|
|
|
|
|
change the database state