Which tables are being locked?

Question

Which tables are being locked?

Barkingdog

SSCoach

Points: 18670
More actions
August 22, 2008 at 11:46 am

#123187

When I use sp_lock I see something like this:
Type: TAB
ObjID 1115151018
When I run select object_name(1115151018)
I got "sptValue" -- which I think is a stored proc.
How can I get more info on locked tables -- for example, the DB name as well at the table name that is locked?
TIA,
barkingdog

Viewing 2 posts - 1 through 2 (of 2 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

sp_lock returns the DB_ID so you can run Select DB_NAME([db_id]) to find the name of the database and then you can run select Object_Name([object_id]) within the context of the database returned by DB_NAME().

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question