You can use SQL Management Studio or SQL Server Enterprise Manager to view all current locks in the system and all current connections with the last command executed on the connection. From the command you can deduct which part of your application is sending the command and thereby causing the problem.