sp_dbcc_updateconfig accepts delete as a value for the str1 parameter, which allows you to delete configuration values that you have set on databases. The syntax is:
sp_dbcc_updateconfig dbname, ‘config_parameter’, ‘delete’
For example, to delete the default value of the max worker processes configuration parameter, enter:
sp_dbcc_updateconfig null, ‘max worker processes’, ‘delete’
To delete the value of the max worker processes configuration parameter for the database my_db, enter:
sp_dbcc_updateconfig my_db, ‘max worker processes’, ‘delete’
