Can Enterprise Manager be set to view Tables with NOLOCK?

microsoft.public.sqlserver.tools

23 Aug 2006 2:38 PM

John Kotuby

We have a number of VB client/server customer installations of ours that use
SQL Server 2000 for up to 50 desks. At times there are locking contention
issues and we find that we can't view tables in EM to discern the nature of
the problem. The only way to look at the data is with Query Analyzer using a
Select with (NOLOCK).

Does anyone know if there is a setting to allow Enterprise Manager to view
tables in NOLOCK (read only) mode?

Thanks all for your responses.

23 Aug 2006 3:05 PM

Roy Harvey

No, I don't believe there is any setting in EM to use NOLOCK and
read-only mode. If there was I would not suggest using it. Query
Analyzer is the correct tool for such queries.

Roy Harvey
Beacon Falls, CT

On Wed, 23 Aug 2006 10:38:29 -0400, "John Kotuby"
<jo***@powerlist.com> wrote:

Show quote

>We have a number of VB client/server customer installations of ours that use
>SQL Server 2000 for up to 50 desks. At times there are locking contention
>issues and we find that we can't view tables in EM to discern the nature of
>the problem. The only way to look at the data is with Query Analyzer using a
>Select with (NOLOCK).
>
>Does anyone know if there is a setting to allow Enterprise Manager to view
>tables in NOLOCK (read only) mode?
>
>Thanks all for your responses.