Howto repair mssql databasse.

ALTER DATABASE [dbname] SET EMERGENCY
ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKCONSTRAINTS
DBCC CHECKDB([dbname], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [dbname] SET MULTI_USER