select TableName=object_name(ss.id), RowCnt=st.rowcnt, ColName=col_name(ss.id,convert(int,substring(ss.colidarray,1,2))), UpdStatsDate=convert(varchar(20),moddate,100), DaysAgo=datediff(dd,moddate,getdate()) from sysstatistics ss, systabstats st where ss.id > 100 and st.id > 100 and ss.id=st.id and ss.formatid=100 and st.indid in (0,1) and ss.c4 is not null order by TableName, ColName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)