Repair a db receiving consistency errors in POS during tenders

Run these scripts individually to confirm if there is a problem:

DBCC CHECKDB ('dbname')

DBCC Checkcatalog ('dbname')

If either script returns 'errors found' message, run the repair procedure below.

Exit RMS on all stations.
Connect to db on server.
Issue the following scripts making sure to close the query box between each script.
Change dbbame accordingly.

ALTER DATABASE dbname SET SINGLE_USER WITH NO_WAIT

DBCC CHECKDB ('dbname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE dbname SET MULTI_USER WITH NO_WAIT

DBCC SHRINKDATABASE (dbname)