Mega Code Archive

 

Categories / MSSQL / System

 

Displaying Database and SQL Server Settings

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)