I faced very strange issue.
When I try from management studio to put the specific database to RESTRICTED_MODE, the operation succeeded,
but when I try to do it from the operation script, I receive a message :
"Msg 5070, Level 16, State 2, Line 3
Database state cannot be changed while other users are using the database 'MyDBName'
Msg 5069, Level 16, State 1, Line 3
ALTER DATABASE statement failed."
- This topic was modified 1 month, 2 weeks ago by genadyd.