/*
adapt the db name and execute each of those steps manually

if data corruption have occured, restoring a backup might need necessary
*/
return 

ALTER DATABASE activepos_read SET EMERGENCY;

dbcc checkdb('activepos_read') WITH ALL_ERRORMSGS, NO_INFOMSGS

ALTER DATABASE activepos_read SET single_user with rollback immediate;

dbcc checkdb ('activepos_read',repair_allow_data_loss)

ALTER DATABASE activepos_read SET multi_user with rollback immediate;