GIRITECH DB RECOVERY

ALTER DATABASE ALAADMINDB SET SINGLE_USER
GO

DBCC CHECKDB('ALAADMINDB', REPAIR_REBUILD)
or
DBCC CHECKDB('ALAADMINDB', REPAIR_ALLOW_DATA_LOSS)

GO

ALTER DATABASE ALAADMINDB SET  MULTI_USER

WHEN THE TABLES ARE  DEAD LOCKED THEN USE THIS QUERY TO UN LOCK IT AND THE SERVER PROCESS WILL BECOME FAST