Re: Enterprise Manager Locks Table

Thanks Andrew.

At least you have confirmed what I susspected. Yes we will be sticking to QA
from know on.

Phil...


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:%23a2iiCuXFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
> 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...
>>
>
>


.

Relevant Pages

  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)
  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Manager Locks Table
    ... Andrew J. Kelly SQL MVP ... > We have just moved a SQL Server database to a new server and since doing ... > viewed in Enterprise Manager until the table is closed. ... > the table is viewed using SQL Anaylser then the table lock does not remain ...
    (microsoft.public.sqlserver.tools)
  • Re: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)
  • Enterprise Manager Locks Table
    ... We have just moved a SQL Server database to a new server and since doing ... viewed in Enterprise Manager until the table is closed. ... using SQL Anaylser then the table lock does not remain even with the result ...
    (microsoft.public.sqlserver.tools)