• barb.wendling (4/12/2009)


    http://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspx

    BOL states:

    When true, users can only read data in the database. Users cannot modify the data or database objects, however, the database itself can be deleted using the DROP DATABASE statement. The database cannot be in use when a new value for the read only option is specified. The master database is the exception, and only the system administrator can use master while the read only option is being set.

    This indicated to me that the master database has the option available...:hehe: - o well..

    We all read that in bol, but noone's been able to set to read_only (even using sa).

    That's why the correct answer's been updated in this one!