In Microsoft SQL Server Management Studio Query Editor execute the following command:
DBCC CHECKDB WITH NO_INFOMSGS;
may span from minutes to hours. It is dependent on the size of
the database and the configuration of the server.
The partial output looks
like below on OK execution if NO_INFOMSGS option is not used:
DBCC results for 'titles'.
There are 18 rows in 1 pages for object 'titles'.
CHECKDB found 0 allocation errors and 0 consistency errors in
DBCC execution completed. If DBCC printed error messages, contact
your system administrator.