Use sp_dbcc_updateconfig to initialize the dbcc_config table for the target database. You must update each dbcc parameter separately for each target database, as shown in the following example:
use dbccdb go sp_dbcc_updateconfig pubs2,"max worker processes", "4" go sp_dbcc_updateconfig pubs2, "dbcc named cache", pubs2_cache, "10K" go sp_dbcc_updateconfig pubs2, "scan workspace", scan_pubs2 go sp_dbcc_updateconfig pubs2, "text workspace", text_pubs2 go sp_dbcc_updateconfig pubs2, "OAM count threshold", "5" go sp_dbcc_updateconfig pubs2, "IO error abort", "3" go sp_dbcc_updateconfig pubs2,"linkage error abort", "8" go
You can now use dbcc checkstorage to check your databases. For descriptions of the dbcc parameters, see type code values 1 through 9 in “dbcc_types” in Chapter 59, “dbccdb Tables” in the Reference Manual.
