SQLTeam.com | Weblogs | Forums

Consistency error


#1

i am getting some consistency error in one of my database, what may be the options to correct the inconsistencies?


#2

Run this:
USE [your_db_name_that_has_the_errors]
DBCC CHECKDB () WITH NO_INFOMSGS

Then, if there are errors on an index number higher than 1, script out the index(es), drop them, then recreate them.

If the index # is 1 (or 0), that is the table itself, and you'll have to look at using one of the REPAIR options.