Enterprise Manager causing blocking

Hi,
We recently had Problems with blockings on some tables.
Now i found that everytime I work in Enterprise Manager and
open up large tables where i need to scroll, EM seems to
lock this table as every update the cusomers do are blocked by
myself.
This really shouldn't happen.
What kind of Tool is this causing Problems while doing queries.
Has anyone similar experiences or some workarounds?
(exept using QueryAnalyzer)
Thanks
Mikepeppi911@.hotmail.com wrote:

> Hi,
> We recently had Problems with blockings on some tables.
> Now i found that everytime I work in Enterprise Manager and
> open up large tables where i need to scroll, EM seems to
> lock this table as every update the cusomers do are blocked by
> myself.
> This really shouldn't happen.
> What kind of Tool is this causing Problems while doing queries.
> Has anyone similar experiences or some workarounds?
> (exept using QueryAnalyzer)
> Thanks
> Mike
Enterprise Manager isn't a good way to edit and enter data. It is a
management tool, not an end-user application. Why would you want to
open and scroll through large tables? Never ever use EM like that in a
multi-user production environment.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi, thanks for answering.
Well users want Results the whole day, so i do special queries
and copy everything in Excel.
QA doesn't even copy the heads so i don't know which way other
that using EM to get the result in a proper way.
Arn't there other Tools?
Does the new Version 2005 do the same?
Greetings,
Mike|||xpeppi911@.hotmail.com wrote:
> Hi, thanks for answering.
> Well users want Results the whole day, so i do special queries
> and copy everything in Excel.
> QA doesn't even copy the heads so i don't know which way other
> that using EM to get the result in a proper way.
> Arn't there other Tools?
> Does the new Version 2005 do the same?
> Greetings,
> Mike
Some options:
In Excel select Data / Import External Data / New Database Query...
Use any one of many query / reporting or data integration tools.
Crystal Reports, Business Objects for example. Some of those will
surely support Excel formats.
Use DTS or SQL Server Integration Services to export in Excel format.
Write your own code or Excel macro to export in Excel format.
Share data by other means without using Excel. You could publish the
data to users through Reporting Services for example (they can still
paste data into Excel if they really want to). This would certainly be
my favoured option. Copy-and-paste is an inherently limited, costly and
inefficient way to share data.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||QA has secrets (that you can use to your advantage):
http://www.sqlservercentral.com/col...
yanalyzer.asp
ML
http://milambda.blogspot.com/