You can manually update the IN_DB_UPGRADE_CONTROL_UPGRADE table to change the default values. To view the current parameter defaults, complete the following step. These default values are used by the various procedures that perform the upgrade steps unless otherwise specified during execution.
In SSMS or at the command prompt (sqlcmd), execute the following command.
SELECT * FROM inuser.IN_DB_UPGRADE_CONTROL_UPGRADE;
Note: The following values are the only values that should ever be modified
in this table. Do not modify any other values.
The values used in the following example are not the defaults in some cases. See the parameter descriptions above for defaults.
UPDATE inuser.IN_DB_UPGRADE_CONTROL_UPGRADE SET DEFAULT_MAX_MINUTES = 60 ,DEFAULT_MAX_DOP = 4 ,DEFAULT_FILLFACTOR = 100;