Rapair MS Sql Table for Error (DBCC)

Error : A possible dabase consistency problem has been detected on databse [dbname]. DBCC CheckdB or DBCC CheckCatalog should be run on database [dbname].

Solution :

check which table creates the problem and run the below comamnds.

1) ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

2) DBCC Checktable('tablename',repair_allow_data_loss)

3) ALTER DATABASE [dbname] SET MULTI_USER;