Derek,

use lock hints within a transaction ( it is not simple to implement and control )

* examples
BEGIN TRAN
... WITH (UPDLOCK,ROWLOCK) ....
* NOW YOU HAVE EXCLUSIVE WRITE ACCESS TO SELECTED ROWS UNTIL ROLLBACK OR COMMIT
* attention, SQL can excalade lock to pages or table

Fabio