Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Doing a select while update transaction...

Author  Topic  vpu Starting Member 7 Posts Posted - 2001-05-03 : 06:15:02 I found an interesting problem that is a bit too difficult for me. Here's what I want do: First I start a transaction which makes an update statement While this transaction is running, I want other users to be able to read(select) the data as it was before my update transaction started. So if I understand correctly I can not make a dirty because it would read the data that has been partly updated and not the data before the transaction started? Thanks for any help! Edited by - vpu on 05/03/2001 06:16:00