The enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
|No repair is performed.|
|Maintains syntax for backward compatibility only. No repair is performed.|
|Performs repairs that have no possibility of data loss. This can include quick repairs, such as repairing missing rows in non-clustered indexes, and more time-consuming repairs, such as rebuilding an index. REPAIR does not repair errors involving FILESTREAM data.|
|Tries to repair all reported errors. These repairs can cause some data loss.|