Database Repair Constants (SQLDMO_DBCC_REPAIR_TYPE)

Database repair constants control behavior of the CheckTables and CheckAllocations methods of the Database object.

Constant Value Description
SQLDMORepair_Allow_DataLoss 3 Attempt all database repair regardless of the possibility of data loss. For example, delete corrupted text objects.
SQLDMORepair_Fast 1 Attempt database repair tasks that do not incur data loss.
SQLDMORepair_None 0 Do not attempt database repair on database inconsistencies encountered.
SQLDMORepair_Rebuild 2 Attempt database repair tasks that do not incur data loss. Rebuild indexes on successful database repair.

See Also
CheckAllocations Method CheckTables Method

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.