Hi

I always thought if I used a rowlock hint during an update it would only
lock the row.
But the system still locks the table with an IX extent lock, so no other
updates to any other row from a different connection can be completed unless
the other update has completed,  or a read accessing another row can not be
completed unless it is a dirty read.

So what is the point in rowlocks if they hold a lock on a table and prevent
reads or updates to a different row. If my understanding is wrong please tell
me.

thanks for any advice

Sammy

Top 100 ... Order by in views SQL 2005 problem
Assistance with SQL Script
SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
HOW TO: PIVOT for unknown number of column headings?
Passing parameter from a recordset in a Stored Procedure