The DATABASEPROPERTYEX returns information about database options.
DATABASEPROPERTYEX uses the following syntax:
DATABASEPROPERTYEX ( database , property )
8>
9> SELECT DATABASEPROPERTYEX('YourDatabaseName', 'Collation'),
10> DATABASEPROPERTYEX('YourDatabaseName', 'Recovery'),
11> DATABASEPROPERTYEX('YourDatabaseName', 'Status')
12> GO
--
NULL
NULL
NULL
(1 rows affected)