|
|
Posted by Bobbo on 08/11/06 09:47
Mark D Powell wrote:
> EM locks data when it reads it.
I don't think that's the case. I've just created a test table, filled
it with some data and viewed it in EM. I could still update one of the
viewed rows using QA. Once I re-ran the EM query using the exclamation
icon again, the changed row reflected its new state.
Surely the result set clearing is because of the resources consumed by
the open connection, rather than any locking? If I'm wrong, somebody
stop me - to quote Jim Carey.
> You should really use Query Analyzer
I agree! It's a much better tool for actually executing queries.
Navigation:
[Reply to this message]
|