Enterprise Manager Locks Table
- From: "Phil Jenson" <phil@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 22 May 2005 14:40:44 +0100
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: Andrew J. Kelly
- Re: Enterprise Manager Locks Table
- Prev by Date: Re: Show Line Numbers?
- Next by Date: Re: Enterprise Manager Locks Table
- Previous by thread: Generating scripts and creating backups
- Next by thread: Re: Enterprise Manager Locks Table
- Index(es):
Relevant Pages
|
