Hi, I want to know whether sql server 2000 can implement locks and timestamp protocol for concurrency control. If yes, how to implement it?

Please provide a few examples of your task.

Jaime E. Maccou

Actually I am trying to update data from two different PCs at almost the same time, so how can I have concurrency control in sql server 2000 so to ensure serializability.

For example, if two users from two different PCs are updating data to sql server at exactly the same time, how sql server knows which data is updated first? I just want to know how to configure sql server to ensure concurrency.

The SQL Server query optimizer automatically makes the correct determination and issue a record lock on the first to grab the record. If you want to change the default behavior you must issue table, record lock hints.

If you look on books online it will tell how to issue these lock hints to ensure concurrency.

I hope this helps

Jaime E. Maccou

Additional: you may look up information on setting the TRANSACTION ISOLATION LEVEL Change certain lock may also escalate the locking process.

Jaime E. Maccou

Thanks a lot, jemacc. I will try on that. :)