How to do row level locking in SQL server 2005?

Hi,
For example, there are 2 users connecting to the same table and want to
update the different rows. They are requested to use the row level locking.
Pls advise and provide the example of sql statement or sample code.
Thank you...for example, as below..
Trans 1 :
UPDATE YourTable WITH (ROWLOCK)
SET YourCol = 'Value'
WHERE ID = 1
Trans 2:
UPDATE YourTable WITH (ROWLOCK)
SET YourCol = 'Value'
WHERE ID = 2
Whats happen is that the Trans 2 will get waiting ...& hanging there until
..the Trans 1 release or commit...
My problem here is ..how could i get a message that ...when the trans 1 is
row lock (updating), the trans 2 will get the message and diplay the allert
to the user.
Thanks
"Connie" <yfchan@.kdu.edu.my> wrote in message
news:uXKVV2vpGHA.2292@.TK2MSFTNGP05.phx.gbl...
> Hi,
> For example, there are 2 users connecting to the same table and want to
> update the different rows. They are requested to use the row level
> locking.
> Pls advise and provide the example of sql statement or sample code.
> Thank you
>
>|||There are several answers to this one on the SQL Server Programming group.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Connie" wrote:
> Hi,
> For example, there are 2 users connecting to the same table and want to
> update the different rows. They are requested to use the row level locking.
> Pls advise and provide the example of sql statement or sample code.
> Thank you
>
>|||You might find this article useful.
http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Connie" <yfchan@.kdu.edu.my> wrote in message
news:uXKVV2vpGHA.2292@.TK2MSFTNGP05.phx.gbl...
> Hi,
> For example, there are 2 users connecting to the same table and want to
> update the different rows. They are requested to use the row level
> locking.
> Pls advise and provide the example of sql statement or sample code.
> Thank you
>
>