I am dbowner of a database which I want to set read-only. (through sql management studio). When I try that I get a permission error (297)
Which role is needed to perform that action?
Form Query Analyzer or Management Studio, you can issue the following command:
As mentioned here, you need the alter database rights and you must set the database to single mode.
There is a system stored procedure. You can also use this for this task.