InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 11:16:35 GMT20http://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspx[quote][b]barb.wendling (4/12/2009)[/b][hr]http://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspxBOL 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..[/quote]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!Sun, 12 Apr 2009 10:05:33 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxhttp://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspxBOL 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..Sun, 12 Apr 2009 05:39:25 GMTBarbWhttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxI tried starting a 2000 SP3 Standard Edition with single user mode with no luck. DAC didn't come along until SQL 2005 so that wouldn't work. Is there anyway to actually make this available!?!Fri, 10 Apr 2009 09:29:34 GMTbeezellhttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxSorry, the question has been corrected after testing on a couple instances. Points awarded back.It appears, even if you are not connected to master, you cannot set this option.Fri, 10 Apr 2009 09:28:12 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxWhen I attempt to put a user database in Read_Only when it is in use, the process hangs waiting for the database to be freed up. I would seem consistent that it would do the same thing for Master if that option were valid.Fri, 10 Apr 2009 09:25:15 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxMaybe using DAC to connect or having the whole server in single user... but then what's the point of setting master to read_only??Fri, 10 Apr 2009 08:47:32 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxI suspect that the reason the error message was because the master database was in use, not because it is invalid to set read only on master. Since all the background processes use master how can there be no users to set read only?Fri, 10 Apr 2009 08:39:24 GMTdunnjoehttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxEven though BOL says it can be done, I tried it on Microsoft SQL Server 2000 - 8.00.2050 Enterprise Edition and it fails there also.Fri, 10 Apr 2009 08:21:18 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxIt's a bit hard to believe that 67% of the people are wrong about this ;).Fri, 10 Apr 2009 08:04:34 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxYes, I tried on Microsoft SQL Server 2000 - 8.00.2039 (Standard Edition) this option is disable on Master database, could be Enterprice edition might be having... question should specify the version and edtion of 2000... else the answer E is right...I want my points.:-DThanxVinayFri, 10 Apr 2009 08:02:44 GMTVinay Thakur-585143http://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxThe original question was asked about 2000, but I tried 2000,2005,2008 and they all gave me the same error. Now the article that was referenced did mention that it could be done on a 2000 master database, but I wonder if one of the service packs changed this functionality this... Still I think the question is invalid.Cheers,BrianFri, 10 Apr 2009 07:00:42 GMTbeezellhttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxThis is what I got when I ran it in 2005...Msg 5058, Level 16, State 5, Line 1Option 'READ_ONLY' cannot be set in database 'master'.Fri, 10 Apr 2009 06:42:15 GMTdunnjoehttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxI agree, but I only ran this against 2005 instance (no access to 2000).makes more sens to not have it read only in the first place.On 2008 it's definitly not possible to make it read only.Fri, 10 Apr 2009 06:15:43 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxI ran this statement against a SQL Server 2000 database and got this message:Msg 5058, Level 16, State 5, Line 1Option 'READ_ONLY' cannot be set in database 'MASTER'.I think the correct answer is E. Anyone else agree with me on this?Fri, 10 Apr 2009 06:09:18 GMTbeezellhttp://www.sqlservercentral.com/Forums/Topic694585-1530-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/SQL+Server+2000/66121/">Read_Only Database </A>[/B]Thu, 09 Apr 2009 21:08:28 GMTUnknown.