For Tricker
select * from SetupMaster where setupdesc like ‘%tri%’
select * from SetupMasterCompTran where Setupmaster_id=12
update SetupMasterCompTran set setupflg=’False’ where Setupmaster_id
in (12)
REPAIRE db
use master
DBCC CHECKDB (DBNAME) WITH NO_INFOMSGS, ALL_ERRORMSGS
ALTER DATABASE DBNAME SET EMERGENCY
ALTER DATABASE DBNAME SET SINGLE_USER
DBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
DBCC CHECKDB (DBNAME, repair_fast)
DBCC CHECKDB (DBNAME, repair_rebuild)
DBCC CHECKDB (DBNAME, repair_allow_data_loss)
DBCC CHECKDB WITH NO_INFOMSGS;
ALTER DATABASE DBNAME SET MULTI_USER