Thanks for the reply ..

Does this mean that we cannot control the behaviour from SQL side .?

Is there something like with "no lock" hint which can be part of the...

i think u can go with Lowells solution.(first reply for this thread)