Enterprise Manager causes blocks?

microsoft.public.sqlserver.tools

6 Jul 2006 12:53 PM

Michi

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

6 Jul 2006 3:39 PM

Arnie Rowland

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."

Show quote

"Michi" <Mi***@discussions.microsoft.com> wrote in message
news:B3A51470-8CF9-4833-92A5-5BFA7391D694@microsoft.com...
> 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