Hi all I need some examples regarding locking of a particular row in a table in sql server 2000, so that other person can't even select that row for any updations. can i can any tips. need help (examples) row-level lock while selecting a row... prabhu