I think the version for SQL server 2005 may be different.
Here’s the 2008 / 12 / 14 version.
SELECT * FROM
FROM sys.sysindexes i with (NOLOCK)
LEFT OUTER JOIN sys.stats s with (NOLOCK)
ON i.name = s.name
CROSS APPLY sys.dm_db_stats_properties(s.object_id, s.stats_id) AS sp WHERE i.id > 100 AND i.indid > 0 AND i.rowcnt >= 5000
AND cast(i.rowmodctr as decimal)/cast(i.rowcnt as decimal) >= .03
AND s.name not like '_WA_Sys_%' AND last_updated <= GETDATE()- 1 ) a WHERE statsdate is not null
Thanks for the SQL.
I have not had to dive into SQL Server objects too much in my past, then tend to typically just run and perform.
This particular object was a view, not a table, even though it called out a Table as the object...
So, I did find the object and have since updated statistics on it...