In SQL Server 2005, how can you lock a specific row against both reads and writes?
===

I know it's probably a little unusual to lock a row against being read from, but it is kind of relevant in this case.  For a row-level lock in SQL Server 2005, how can you lock a row for both reads and writes?  Thanks!