Updated Statistics for tables in sql 2000 1

[manmaria]

How do I know which tables are upto the date for the Stats?
I need this for sqlserver 2000.

TIA

 

[SQLBill]

Try this:

SELECT 'Index Name' = i.name, 
   'Statistics Date' = STATS_DATE(i.id, i.indid)
FROM sysobjects o, sysindexes i
WHERE o.id = i.id
GO

Or you can update the script to use JOINs. This is out of the BOL.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[manmaria]

Thank you. It works.