Although much of the prefacing information about the query optimizer's use of statistics to determine the best way to resolve a query are applicable to SQL Server 2000 and 2005, the script that I included in my last post to determine that last time that the statistics were updated was specific to SQL Server 2005. The sys.indexes view does not exist in the prior version of SQL Server.
I've updated, or rather backdated, the script to work with SQL Server 2000. (It still works under SQL Server 2005).
SELECT
o.name AS Table_Name
,i.name AS Index_Name
,STATS_DATE(o.id,i.indid) AS Date_Updated
FROM
sysobjects o JOIN
sysindexes i ON i.id = o.id
WHERE
xtype = 'U' AND
i.name IS NOT NULL
ORDER BY
o.name ASC
,i.name ASC
Enjoy!
Joe
