I fount the solution.

Actually I was looking for the Transaction which behaves like ORACLE.

Like While Read Pessimetic

abd while Update Opptimistic

This is available in SQL server 2005 by introducing two new...

Actually I was facing the problem in sql server 2000. I found there is no way in SQL server 2000; except the dirty read.

Any how my company planning to upgrade...

I hope I not made my question very clear.

My question is:

In my table already I have some data like 1,'test','niraj test'

Now the situation is:

User1 from one system run the query...

I have to read committed data.

But not able to read the committed data also

what I do for that