Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dev2dev
Starting Member
48 Posts |
 Posted - 2008-04-16 : 11:25:26
|
sorry for short subject, it allows very less characters, seems like varchar(50)  Hi,My questions is...How to identify an object using its objectid. In profiler and activity monitor we see objects like 1:123451:2345:453454and so on...I am sure they are not tables or indexes and I guess they are something related to pages, rowids etc.,how do i interpret these objects (ids) and point back to the table (if it belongs to any table)to summarize what I wanthow to identify the type of object is being shown in profiler/activity monitorhow to identify to which table/index that object belongs/associatedwhere can i get object name for any object id that is shown in profiler/activity monitor. some time it shows some object ids in 100s of thousands for which i don't see any entry in sysobjects/sysindexesThanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-16 : 12:12:51
|
| Depends where it's coming from. Could be a file number and page number.Have a look at this for how to find the entry.http://www.nigelrivett.net/SQLAdmin/PageStructure.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dev2dev
Starting Member
48 Posts |
Posted - 2008-04-17 : 08:56:01
|
| broken link |
|
|
|
|
|
|
how2identify, which table does the object belongs