• You can use the WITH UPDLOCK clause in your update query.

    There's a good thread on it here;

    http://stackoverflow.com/questions/1921091/thread-safe-sql-transaction-how-to-lock-a-specific-row-during-a-transaction