I'm looking for a SQL Server 2005 query that will list all the indexes and with their respective STATISTICS\_NORECOMPUTE value. I didn't see any obvious value in sysindexes that corresponds to that value.