我有一个离线的2008 sql数据库,我想在线并设置为多用户.使用sql server management studio – 新的查询窗口 – 当我执行以下命令时：
ALTER DATABASE mydb SET ONLINE;
ALTER DATABASE mydb SET MULTI_USER;
我收到此错误消息：
Msg 5064,Level 16,State 1,Line 1
Changes to the state or options of
database ‘mydb’ cannot be made at this
time. The database is in single-user
mode,and a user is currently
connected to it.
Msg 5069,
State 1,Line 1 ALTER DATABASE
statement Failed. Msg 5064,Line 3 Changes to the state
or options of database ‘mydb’ 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,Line 3 ALTER
DATABASE statement Failed.
