May 24, 2007 at 1:53 am
Is it possible for a user to unlock another users record lock?
We have an asp.net application where there are two types of user admin and user.
if the user locks a particular record, but the admin person want to lock that same record then he has preceedence over this. and i want to be able to unlock the users lock on the record and allow the admin person to get a lock on it?
Many thanks in advance...
July 5, 2007 at 1:50 pm
Locking is used to guarantee consistency.
If you would be able to 'steal' a lock in the middle of a transaction it would break down the whole point of locking.
July 6, 2007 at 7:24 am
What kind of lock are you talking about? SQL provides its own type of locking used to guarantee data integrity. These locks are controlled by using lock hints in TSQL code and/or designing your database and application the right way for the intended solution. Search SQL Server Books Online for locking.
If you are talking about locks at the application level, this is a whole other animal...
What are you trying to accomplish?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply