MsSQL dbname(Suspect)

EXEC sp_resetstatus dbname;
ALTER DATABASE dbname SET EMERGENCY;

DBCC checkdb('dbname');
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE dbname SET MULTI_USER;