sql server programming: Hello,

I have a table with a lot of records.
The records can be selected/update/inserted/deleted with a XML webservice.

On the same time:
One user select * records.
Second user update record x.

This means that the index has changed.... and posible the first user has
wrong data.

What can I do about this?

Thanks!

Hello !

SQL Server provides read consistency. means that even another user is
accessing the data, it can be read through another user. The problem that
after quering the data, it could be out-of-date is a gernell problem in your
coding/ database due to heavy access to the db.

Jens Süßmeyer.


"Arjen" <boah123@hotmail.com> schrieb im Newsbeitrag
news:bjlehp$uau$1@news2.tilbu1.nb.home.nl...
[quoted text, click to view]