is there any sample way to row lock in the mssql server.
and also how to check which the row is locked .

I am only use a table to store the table name and the control id for the lock info.

is there any alternative method ?