Resolving SQL Server database tables is dead!

--kill all Deadlock processes
ALTERProcSp_killallprocessindb
@DbNameVarChar( -)
as
ifdb_id(@DbName)=Null
begin
Print'DataBase dose not Exist'
End
Else

Begin
Declare@spId Varchar( -)

DECLARETmpcursorCURSOR for
Select'Kill'+Convert(Varchar, spid) asSpId
fromMaster.. sysprocesses
wheredb_name(DbID)=@DbName
andSpId<>@ @SpId
andDbID<>0
OPENTmpcursor

FETCHNEXT fromTmpcursor
into@spId

while@ @FETCH_STATUS=0

BEGIN

Exec(@spId)

FETCHNEXT fromTmpcursor
into@spId

END


CLOSETmpcursor
deallocateTmpcursor

End

GO
--To Execute
ExecDbo. SP_KILLALLPROCESSINDB database name