InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:39:52 GMT20http://www.sqlservercentral.com/Forums/Topic487988-9-1.aspxAh! The 'null' records are just the totals! It's all fine... :)Mon, 21 Apr 2008 10:16:03 GMTRyanRandallhttp://www.sqlservercentral.com/Forums/Topic487988-9-1.aspxOK, seems to be a side effect of using 'GROUP BY id with rollup' When I drop the rollup all the objects are found. odd???SET NOCOUNT ONselect id, cast(object_name(id) as varchar(50)) AS name, sum(CASE WHEN indid<2 THEN rows END) AS rows,sum(reserved)*8 AS reserved, sum(dpages)*8 AS data, sum(used-dpages)*8 AS index_size, sum(reserved-used)*8 AS unusedfrom dbo.sysindexes with (nolock) where indid in(0,1,255) and id>100 GROUP BY id with rollupORDER BY sum(reserved)*8 descMon, 21 Apr 2008 09:52:41 GMTMike-292078http://www.sqlservercentral.com/Forums/Topic487988-9-1.aspxThat doesn't sound right, I'm logged as the Administrator.Mon, 21 Apr 2008 09:40:00 GMTMike-292078http://www.sqlservercentral.com/Forums/Topic487988-9-1.aspxCould it all be permissions related?BOL ([url]http://technet.microsoft.com/en-us/library/ms186301.aspx[/url])..."built-in functions such as OBJECT_NAME may return NULL if the user does not have any permission on the object"Mon, 21 Apr 2008 09:00:49 GMTRyanRandallhttp://www.sqlservercentral.com/Forums/Topic487988-9-1.aspxHI:I'm doing some analysis trying to figure out what's making my database so big. I'm querying the sysindexes and I'm finding something very off.There are rows in the table where id is null and there are rows where object_name(id) is returning null. There appears to be a lot of data in these.Any idea what these object are?Thanks-MikeMon, 21 Apr 2008 08:08:53 GMTMike-292078