mssql dbcc repair

step
Exec sp_resetstatus 'DBNAME'

Alter Database DBNAME SET EMERGENCY

DBCC checkdb ('DBNAME')

Alter Databases DBNAME Set Single_User with
Rollback Immediate

DBCC CheckDB('DBNAME', Repair_Allow_Data_Loss)

Alter Database DBNAME Set Multi_User

MSSQL Restart

** reference 
running status with mssql 2005 above
select session_id, start_time, status,
command, percent_complete,
estimated_completion_time
from sys.dm_exec_requests
where session_id=53

single user error
SELECT request_session_id
FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID('DBNAME')

KILL 51