Figuring out the resource a lock in SQL Server 2000 affects

Posted by Michael Lang on Stack Overflow See other posts from Stack Overflow or by Michael Lang
Published on 2010-04-05T17:17:57Z Indexed on 2010/04/05 17:23 UTC
Read the original article Hit count: 190

Filed under:

sql-server-2000

|

lock

|

deadlock

I am adding a simple web-interface to show data from a commercial off the shelf (COTS) application. This COTS issues locks on any record the user is actively looking at (whether they intend to edit and update it or not).

I have found sp_lock and the Microsoft sp_lock2 scripts and can see the locks, so that's all well and good.

However, I cannot figure out how I can tell if a specific record I am about to update has been affected by one of these locks. If I submit the update request and there is in fact a lock, the web-interface will wait indefinitely until the user closes the window in the COTS.

How can I either:

a) determine before issuing an update that the record has been locked

OR

b) issue an update that will immediately return with a LOCKED status rather than indefinitely waiting on the COTS user to close their window on that record?

© Stack Overflow or respective owner

Related posts about sql-server-2000

sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users

as seen on SQL Authority - Search for 'SQL Authority'
If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the… >>> More
Syncsort's Backup Express Supports SQL Server 2000 and DB2-UDB in SAP Solution Environments

as seen on Internet.com - Search for 'Internet.com'
A SQL Server 2000 and a DB2-UDB SAP Solution Environment Integration Assessment of Syncsort Incorporated's enterprise data backup and restore product, Backup Express, asserted that Backup Express provides high value to SAP customers. >>> More
SQL Server 2000 (8.0) SP 4 crash after load Linked Servers

as seen on Server Fault - Search for 'Server Fault'
Hello I configured one Oracle 10g Linked Server on my SQL Server 2000, so two days ago I can view the tables and views, today when I try to check it again I get an connection error, something with latency and time out operation "readsni" in the process of login the sa user. Then I lost all connections… >>> More
SQL Server 2000 incorrect message: duplicate key with unique index

as seen on Stack Overflow - Search for 'Stack Overflow'
Database server: SQL Server 2000 - 8.00.760 - SP3 - Standard Edition I have a table with 5 columns, in which I want to add a large (300.000) number of records. There is a unique index on the combination of two columns. If I add the records with this unique index in place, SQL Server gives this error… >>> More

Related posts about lock

How to create a shared lock blocking an intent exclusive lock

as seen on Server Fault - Search for 'Server Fault'
As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive lock then that UPDATE statement will need to wait until the SELECT statement releases its shared locks… >>> More
Lock Question - 'U' lock vs. 'X' lock

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a couple questions concerning Update (U) locks and Exclusive (X) locks. 1) Am I correct that an 'X' lock is put on a resource when the resource is about to get updated? 2) I'm a little fuzzy on U locks. Am I correct that a U lock is applied when a resource is read and SQL Server thinks it… >>> More
How pattern lock disbles screen lock in android

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, In android 2.1, if we enable pattern lock, then the screen lock (slide to unlock) is not displayed and if pattern lock is disabled then screen lock is enabled again. Can someone point me out the java file in framework and the function where this happens. I mean when the screen is about to get… >>> More
Why lock-free data structures just aren't lock-free enough

as seen on Simple Talk - Search for 'Simple Talk'
Today's post will explore why the current ways to communicate between threads don't scale, and show you a possible way to build scalable parallel programming on top of shared memory. The problem with shared memory Soon, we will have dozens, hundreds and then millions of cores in our computers… >>> More
Java ReentrantReadWriteLocks - how to safely acquire write lock?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using in my code at the moment a ReentrantReadWriteLock to synchronize access over a tree-like structure. This structure is large, and read by many threads at once with occasional modifications to small parts of it - so it seems to fit the read-write idiom well. I understand that with this… >>> More