Deleting Configuration Values

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.

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'