table lock

Question

table lock

newbieuser

SSCrazy Eights

Points: 9423
More actions
September 17, 2009 at 12:24 pm

#226300

HI all,
User claims that he is not able to update a record in a table and he gets this message as ' THe record is locked by other users. Try again' . I need to release this lock or kill the session that locked this table. On SSMS, activity monitor, I see Locks by Object, but doesnt tell me which session locked this table. I just see 7 sessions in this database.
Is there a way I can find out which session has locked this object?
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

That has to be an application message. SQL Server doesn't notify you of a lock. It just tries to wait until a timeout elapses, or the lock clears.

Applications sometimes raise a semaphore by making a mark on the record or in a table. If they see a mark for that row, they give the user a message.

newbieuser SSCrazy Eights Points: 9423 More actions · Answer 2

So, there is no lock in the SQL server?

Can you please tell me how can I find the locked table in the database? I tried sp_lock but it doesnt say which table is locked..

Thanks

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

There probably is a lock. In SSMS, activity monitor, look at process info all the way to the right under "blocked by" and "blocking". Sort the "blocking" column and see if you get a spid, then right click "details" to see what it's running.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

We can't know if there's a lock. You can check for blocking, as noted above, but what application is it? I might suggest you contact the vendor for that application.