Re: Enterprise Manager causes blocks?

That's because Enterprise Manager holds locks open and Query Analyzer does
not.

You should not use EM on a production database.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



"Michi" <Michi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B3A51470-8CF9-4833-92A5-5BFA7391D694@xxxxxxxxxxxxxxxx
Hello,

can someone explain this behavior?
If I make a select using the enterprise manager, I cause blocks in an
table
another tool is writing in. But if I use the query_analyzer no blocks
happen.

Does anyone know why?

Regards
Michael


.

Relevant Pages

  • Restricted access to Enterprise manager
    ... I want to restrict the access to enterprise manager from the developer ... They need the access the develpment machine so they require ... the production database from their workstation enterprise manager. ...
    (microsoft.public.sqlserver.clients)
  • Re: Restricted access to Enterprise manager
    ... > I want to restrict the access to enterprise manager from the developer ... They need the access the develpment machine so they require ... > the production database from their workstation enterprise manager. ...
    (microsoft.public.sqlserver.clients)
  • Problems in exporting constraints and keys
    ... When i try to replicate a production database as a new development database ... by creating an empty DB called, say 'AppDev' in Enterprise Manager, and then ... export the data using the Tasks->Export Data, the constraints, Primary Keys ...
    (microsoft.public.sqlserver.clients)
Loading