DivyaMohankumar (7/30/2013)

---

Good question.... I wish to Share some of the points:-P:

->DBCC CHECKDB - Checks the logical and physical integrity of all the objects in the specified database.

->DBCC CHECKALLOC – Checks the consistency of disk space allocation structures for a specified database.

->DBCC CHECKTABLE – Checks the integrity of all the pages and structures that make up the table or indexed view.

->DBCC CHECKCATALOG – Checks for catalog consistency within the specified database. The database must be online.