Home Forums SQL Server 2005 Administering deadlock RE: deadlock
balaji.ganga
SSCrazy
Points: 2280
More actions
August 17, 2010 at 6:53 am
#1207843
Hi,
you need find out, if any blocks occurred in your database
use master
select * from sysprocesses where open_tran<>0
if any uncommitted transactions occurred in your database. blocks are created. Check it and fix
it.
With Regards
Balaji.G