ADO Connection, Enterprise Manager and table locks?

Does it make sense that when I run a Select query in Enterprise Manager (not
query analyzer) an application (using an ADO connection) may not be able to
update that same table at the same time?
Could it be that the Enterprise Manager locks that table at the moment the
query's being run? The problem doesn't occur when I run the query with query
analyzer.
Thanks.Enterprise Mangler does indeed set some locks and hold them as long as you
have the query results open in a window. Query Analyzer just gets the data
and releases the locks.
Enterprise Mangler should NOT be used to query data (or even just look at
the contents of tables) on a production server.
Use Query Analyzer for queries.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"VMI" <VMI@.discussions.microsoft.com> wrote in message
news:297149A6-92E3-4ABA-83D5-6A3B0213D7D3@.microsoft.com...
> Does it make sense that when I run a Select query in Enterprise Manager
> (not
> query analyzer) an application (using an ADO connection) may not be able
> to
> update that same table at the same time?
> Could it be that the Enterprise Manager locks that table at the moment the
> query's being run? The problem doesn't occur when I run the query with
> query
> analyzer.
> Thanks.|||VMI wrote:
> Does it make sense that when I run a Select query in Enterprise Manager (n
ot
> query analyzer) an application (using an ADO connection) may not be able t
o
> update that same table at the same time?
> Could it be that the Enterprise Manager locks that table at the moment the
> query's being run? The problem doesn't occur when I run the query with que
ry
> analyzer.
> Thanks.
In spite of all it's pointy-clicky-makes-SQL-look-like-Excel goodness,
Enterprise Manager should not be used to access your data. Aside from
locking problems, it's far too easy to type something into the data
grid, resulting in modified data in your table. Stick to Query Analyzer
and write your own queries...