Locks on the procedure

Hi,

I had had session which kept holding lock on the procedure. I've killed this session so it was marked as 'killed'. Lock remained and server tries to rollback transaction (I suppose). Can I remove this lock in any way or should I wait for the transaction to be rollbacked (but it lasts too long for me)??

Any thoughts

szalas

--
Posted via http://dbforums.com