Hi,

I'm trying to change database from restricted_mode to multi_user mode. I'm
running the following command:

ALTER DATABASE MyDatabase
SET MULTI_USER WITH ROLLBACK IMMEDIATE

If any user is connected to database, the above statement fails and gives
the error as shown below:

Msg 1222, Level 16, State 28, Line 2
Lock request time out period exceeded.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.

Why does it happen? Why termination option doesn't work here?

Thanks,
Suresh

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
create a sp from query output