Various setting of a database with MS SQL Server

You query many of the settings are stored with DATABASEPROPERTYEX

SELECT 'sql911: ' + CAST(DATABASEPROPERTYEX( 'sql911', 'Status') AS VARCHAR(10)) AS 'Status',
    CASE DATABASEPROPERTYEX( 'sql911','IsAutoCreateStatistics')
      WHEN 1 THEN 'Auto'
      WHEN 0 THEN 'Manually'   
    END AS 'Update Stats',
    CASE DATABASEPROPERTYEX( 'sql911','IsAutoShrink')
      WHEN 1 THEN 'Auto'
      WHEN 0 THEN 'Manually'   
    END AS 'Shrink Size',
    CASE DATABASEPROPERTYEX( 'sql911','IsFulltextEnabled')
      WHEN 1 THEN 'Yes'
      WHEN 0 THEN 'No'   
    END AS 'Full Text',
    CASE DATABASEPROPERTYEX( 'sql911','IsPublished')
      WHEN 1 THEN 'Yes'
      WHEN 0 THEN 'No'   
    END AS 'Published',
    CAST(DATABASEPROPERTYEX( 'sql911','Recovery') AS VARCHAR(15)) AS 'Recovery model',
    CAST(DATABASEPROPERTYEX( 'sql911','Updateability') AS VARCHAR(15)) AS 'Updateable',
    CAST(DATABASEPROPERTYEX( 'sql911','Useraccess') AS VARCHAR(15)) AS 'User Access'
Status             Update Stats Shrink Size Full Text Published Recovery model  Updateable      User Access
------------------ ------------ ----------- --------- --------- --------------- --------------- ---------------
sql911: ONLINE     Auto         Auto        No        No        FULL            READ_WRITE      MULTI_USER

(1 row(s) affected)
  1. You just need to give the database name.
  2. You ask for the attribute that you want.