Higher numbers have a greater (they “weight” have a higher priority), and will be processed earlier than lower numbers. The range of GroupTableOrder weight numbers is 0-255. For more information, see To: Process “How databases in a specific order”. DefaultTimeEstimateMins int How long you estimate the operation will take, in minutes. If you want to the operation based off of time (e.g., run for two hours), and the table has never been run before. So, the system has no way to know how long the operation will take. PreferredServer varchar For remote CheckDB runs, the name of the remote server. TableOrderType varchar Order the table using different metrics, such as size, usage, etc. This field is not yet in use. NoIndex bit DBCC CheckTable option NOINDEX. Specifies that intensive checks of nonclustered indexes for user tables should not be performed. RepairOption varchar The repair option to use. This field is not yet in use. Future valid values may include: NULL NONE REPAIR_ALLOW_DATA_LOSS REPAIR_FAST REPAIR_REBUILD RepairOptionAgree bit Signifies that you agree to the repair option specified in the RepairOption column. This is in place because some repair options (i.e., can cause “REPAIR_ALLOW_DATA_LOSS”) you to lose data. This field is not yet in use. AllErrorMsgs bit DBCC CheckTable option ALL_ERRORMSGS. ExtendedLogicalChecks bit DBCC CheckTable option EXTENDED_LOGICAL_CHECKS. NoInfoMsgs bit DBCC CheckTable option NO_INFOMSGS. Suppresses all informational messages. IsTabLock bit DBCC CheckTable option -tablock. Causes DBCC CHECKTABLE to obtain a shared table lock instead of using an internal database snapshot.
Higher numbers have a greater “weight” (they have a higher priority), and will be processed earlier than lower numbers. The range of GroupTableOrder weight numbers is 0-255. For more information, see “How To: Process databases in a specific order”. DefaultTimeEstimateMins int How long you estimate the operation will take, in minutes. If you want to the operation based off of time (e.g., run for two hours), and the table has never been run before. So, the system has no way to know how long the operation will take. PreferredServer varchar For remote CheckDB runs, the name of the remote server. TableOrderType varchar Order the table using different metrics, such as size, usage, etc. This field is not yet in use. NoIndex bit DBCC CheckTable option NOINDEX. Specifies that intensive checks of nonclustered indexes for user tables should not be performed. RepairOption varchar The repair option to use. This field is not yet in use. Future valid values may include: NULL NONE REPAIR_ALLOW_DATA_LOSS REPAIR_FAST REPAIR_REBUILD RepairOptionAgree bit Signifies that you agree to the repair option specified in the RepairOption column. This is in place because some repair options (i.e., “REPAIR_ALLOW_DATA_LOSS”) can cause you to lose data. This field is not yet in use. AllErrorMsgs bit DBCC CheckTable option ALL_ERRORMSGS. ExtendedLogicalChecks bit DBCC CheckTable option EXTENDED_LOGICAL_CHECKS. NoInfoMsgs bit DBCC CheckTable option NO_INFOMSGS. Suppresses all informational messages. IsTabLock bit DBCC CheckTable option -tablock. Causes DBCC CHECKTABLE to obtain a shared table lock instead of using an internal database snapshot.
MinionCheckDB1.0.docx