No object names from dm_db_index_physical_stats view!

[Antzz]

Hi All,
I was doing a select from dm_db_index_physical_stats view from our production server. Each entry has an object_id but when I try to convert them to object_name then I see the values as null.

Any ideas?

Thanks

A

Example
Object Name Object ID Index Id index desctipion
NULL 820913996 1 CLUSTERED INDEX
NULL 1317579732 1 CLUSTERED INDEX
NULL 286676119 1 CLUSTERED INDEX

 

[ptheriault]

how are you trying to get the object name?

It should be like this.

SELECT object_name(s.object_id)

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

 

[Antzz]

Yes I tried the same syntax. But it was my bad - I was trying to make the select from the wrong database. LOL