SQL Server/T-SQL Tutorial/System Functions/DATABASEPROPERTY

SELECT DATABASEPROPERTY("mydb", "IsReadOnly")

   <source lang="sql">

4> SELECT DATABASEPROPERTY("mydb", "IsReadOnly") 5> GO

---

      NULL

(1 rows affected)</source>