sp_dbcc_updateconfig allows you to provide default configuration values for dbcc configuration parameters. In earlier versions of Adaptive Server, you provided individual configuration values for every database that checkstorage analyzed. Although you can still provide these configuration values for an individual database, you can now set default values that are applicable to all databases that do not have a corresponding configuration value (that is, configuration values cannot conflict).
The syntax for sp_dbcc_updateconfig has not changed; to configure the default values, enter a null dbname parameter for sp_dbcc_updateconfig.
For example, after issuing the following, the dbcc configuration parameter max worker processes has a default value of 2:
sp_dbcc_updateconfig null, ‘max worker processes’, ‘2’
To configure a different value for a specific database, substitute the database name for the null value in the command above:
sp_dbcc_updateconfig my_db, ‘max worker processes’, ‘1’
