How to repair a “suspect” state database in MSSQL (Sample SQL Script)

EXEC sp_resetstatus [intellix];
ALTER DATABASE [intellix] SET EMERGENCY
DBCC checkdb([intellix])
ALTER DATABASE [intellix] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([intellix], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [intellix] SET MULTI_USER