Locks in SQL2000

How to lock a Row in SQL2000 so that nobody can select that row.

I applied ROWLOCK, but i am not finding the way.

My query is"SELECT * FROM tablename WITH (ROWLOCK)"

Is this the correct way to write locks.

I would be thankful if u help me

Hi,

Maybe the following link is helpful to you.

Row-Level Locking Using ADO & SQL Server http://support.microsoft.com/kb/252317

Thanks.

|||

Hi all,

I am using SQLServer 2000 & .Net 2003 (1.1 framework)

I had a database calledDATA and the fields ID, Name, Remarks, etc...

I need to give access all the data to my employees in their browser machines.

Number of employees may be from 50 to 150.

If a particular record is fetched by 2 users simultaneously one person is getting an error. For this i need to put locks in the database.

If a particular record is fetched by 1 user, then immediately the another employee who is accessing it, should get another record/data.

Being keeping in mind, how can i solve this scnario?

Any body please help me...

Regards,

Jai Shankar