Sorted it out !

Use database_name

GO

ALTER DATABASE database_name SET SINGLE_USER

GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)

GO

Thanks...Mike