check with sp_who2 , which spid is locking that table
then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there
then decide which spid you can kill
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)