dbcc dbrepair with newthreshold:
Loads thresholds in a database, from systhresholds to dbtable->dbt_thresholds.
Sets up the threshold pointers in each segment according to the levels of the thresholds on the segment, and the segment free page count.
Specifies the segment name or number, and reads all thresholds in systhresholds into dbt_thresholds. Only dbt_thresholds segment’s thresholds are set up according to the thresholds that belong to the dbt_thresholds segment and the segment free page count.
dbcc dbrepair with newthreshold is used by sp_addthreshold, sp_dropthreshold, and sp_modifythreshold. For more information about these stored procedures and complete documentation of dbcc dbrepair, see the most recent version of the Adaptive Server Enterprise Reference Manual: Commands.
