Re: Enterprise Manager Locks Table
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Sun, 22 May 2005 11:12:05 -0400
Make sure you have proper indexes on the table. Using EM to view data has
never been a recommended way. I have seen the behavior plenty of times when
clients use EM to view the data. Using QA and running regular select
statements is the best way to do that.
--
Andrew J. Kelly SQL MVP
"Phil Jenson" <phil@xxxxxxxxxxxxxxxxxxx> wrote in message
news:OlyPbPtXFHA.796@xxxxxxxxxxxxxxxxxxxxxxx
> We have just moved a SQL Server database to a new server and since doing
> this I have found that a lock is placed on a table whenever it is being
> viewed in Enterprise Manager until the table is closed. This has the
> effect of stopping our main program from updating the table whislt it is
> open in Enterprise Manager. If the table is viewed by including
> WITH(NOLOCK) in the select statment then our main program works okay. If
> the table is viewed using SQL Anaylser then the table lock does not remain
> even with the result set still open. I am not sure if this happens on all
> tables but the table in question contains 125,000 rows.
>
> I was not aware of this behavour before (when the database was on another
> server) is this normal and is there a way of forcing Enterprise Manager to
> include WITH(NOLOCK) by default or is something strange happening?
>
>
> Thanks
>
> Phil...
>
.
- Follow-Ups:
- Re: Enterprise Manager Locks Table
- From: Phil Jenson
- Re: Enterprise Manager Locks Table
- References:
- Enterprise Manager Locks Table
- From: Phil Jenson
- Enterprise Manager Locks Table
- Prev by Date: Enterprise Manager Locks Table
- Next by Date: Re: Show Line Numbers?
- Previous by thread: Enterprise Manager Locks Table
- Next by thread: Re: Enterprise Manager Locks Table
- Index(es):
Relevant Pages
|
