Hi

In SQL 2000, sometimes it takes a long time to fetch data from a very  
simple table that in normal cicumestances I can get the information in a  
glance. and when I take look at
(enterprise manager->management->current activity->locks/process id)
I'll find some spids with red icon in blocking mode, so by right clicking  
and killing the process I can get ride of them.
and I 've found in lock/objects when I have a view or procedure which is  
locked all its tables are locked too.
I want to know when this problem occure and why? how can I prevent any  
locking?
or how can I be informed when a lock object happened to go and kill  
it?(should I accidently discover it?)

any help on this issue would be appreciated.