CODE: DBCC CHECKDB

Classic way to check the database is alright.

DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS