How to detect a SQL Server database's read only status using tsql

Question

I need to know how to interrogate my Microsoft SQL Server to know if a given database has been set to read only or not. Is that possible?

Answer 1

The information is stored in sys.databases.

SELECT name, is_read_only 
FROM sys.databases 
WHERE name = 'MyDBNAme'
GO

--returns 1 in is_read_only when database is set to read-only mode.

Answer 2

Here is a command to display or set this property.

EXEC sp_dboption "AdventureWorks", "read only"

Sample output

OptionName CurrentSetting    
read only OFF