Get Table Name 3

[vbkris]

Hi,

Is there any command to get the table name from page infromation?

e.g.:
Page Info:
PAG: 7:1:1420172

I got this page info from the SQL Server log.
I would like to know which table this page belongs to...

Known is handfull, Unknown is worldfull

 

[JackVam]

Have you also got the page header information , because you can grab the "m_objid" from the page header , and then : select object_name( my_obj_id ) , which will give you the table name , assuming it's a table


All the IT jobs in one place -

http://www.ITjobfeed.com

 

[vbkris]

unfortunately that info is not there in the log.

the complete message is:

The program ".Net SqlClient Data Provider" has been blocked for 1 minutes on database DB_NAME in the SQL instance INST_NAME. The defined acceptable blocking threshold is 1 minute(s). ".Net SqlClient Data Provider" is running on SPID 197 as login user1 and is blocked by SPID 95. The resource id is TAB: 7:469576711 []


Known is handfull, Unknown is worldfull

 

[ptheriault]

vbkris,
This first number in 7:469576711 is your database id the second number is the object id. If you run this select from that database it will give you the object name

SELECT OBJECT_NAME(469576711)


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[vbkris]

thanks guys.

that worked. However how can i do this with the Page combination? TAB means table right???

Known is handfull, Unknown is worldfull

 

[SQLDenis]

SELECT OBJECTPROPERTY(469576711,'IsTable')
will return 1 if the object is a table

lookup OBJECTPROPERTY in BOL for all the other properties

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[vbkris]

thanks for all your help guys .

i will go into these functions and get back to you...

Known is handfull, Unknown is worldfull