The syntax is:
dbcc checkverify(dbname)
where dbname is the database for which you want to verify checkstorage results.
checkverify operates on the results of the last completed checkstorage operation for the specified database only.
When the checkverify operation is complete, Adaptive Server returns the following message:
DBCC checkverify for database name, sequence n completed at date time. n suspect conditions resolved as faults and n resolved as innocuous. n checks were aborted.
You can run checkverify automatically after running checkstorage by using sp_dbcc_runcheck.
