Viewing the Current Configuration Values

The sp_dbcc_configreport 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.

For example to view only the configured default values, use either:
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 null, 'false'