Ninja's_RGR'us (8/10/2011)
Can you rephrase Gail? No sure your statement makes sense.Do you mean that locks ar not taking place at all?
A database that is in read only never opens any locks as no concurrency can change the data during the select transaction.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA