Is it possible to put a database into READ ONLY mode from MULTI USERS mode? I know that the following script will bring a database out of READ ONLY---


ALTER DATABASE foo SET SINGLE_USER WITH ROLLBACK IMMEDIATE

restore database foo
with recovery

ALTER DATABASE foo SET MULTI_USER