Checking for Locks in MS Sql Server 2005

[aba]

1. Goto Management Studio and login
2. click plus in front of Management and double click Activity
Monitor, and wait for it to open.
3. In this the first column you can see either one of the following 3
things, a green tick, a red down arrow, or a hourglass.
4. The Hourglass is the lock indication...
5. If you see the hourglass then scroll to your right to the end, you
will find two columns named Blocking and Blocked by
6. If blocking is 1 then check for blocked by. You will a number
there. That is the id of the process which is blocking the operation
of this id, creating a lock...
7. Scroll Left, and right click the process id which you found in
blocked by field, and choose kill process.
8. After every time you do a kill process, then you will have to
refresh the status (you can find the refresh button at the top)