Viewing the current configuration values

The sp_dbcc_configeport defaults parameter allows you to view the configured default values. The defaults parameter is optional, and is ignored if dbname is not null. Valid values for the defaults parameter are true or false (the default). A value of true indicates that you want to display only the default on the configured values. A value of false indicates that you want to view all configured values.

The syntax for sp_dbcc_configreport is:

sp_dbcc_configreport [dbname [, defaults [true | false]]]

For example to view only the configured default values, enter true for the defaults parameter:

sp_dbcc_configreport null, ‘true’

To view all configured values, do not provide a value for the defaults parameter, or use “false:”

sp_dbcc_configreport

Or,

sp_dbcc_configreport null, ‘false’