The information in this article applies to:
SUMMARYThe query tools Microsoft Query and Q+E (which ship or have shipped with Microsoft Excel) can cause a long-term shared page lock on SQL Server when browsing data. Under some conditions, this can block updates to the table. This is because data modification queries can require an exclusive page or table lock, which can be blocked by the outstanding shared page lock from Q+E or Microsoft Query. MORE INFORMATION
You can identify whether this has happened by running the SQL Server query
sp_lock. Identify which SPID number corresponds to the client computer
running Q+E or MS Query, and then note whether a sh_page lock exists.
Additional query words: Windows NT
Keywords : kb3rdparty SSrvWinNT |
Last Reviewed: March 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |