>if object_ID('TempDB..#Stats') is not null > drop table #Stats > >create table #Stats (TableName varchar(128), Statistics_Name varchar(128), Statistics_Keys varchar(128)) > >if object_ID('TempDB..#Stats_Temp') is not null > drop table #Stats_Temp > >create table #Stats_Temp (Statistics_Name varchar(128), Statistics_Keys varchar(128)) > >exec sp_MSforeachtable > 'insert into #Stats_Temp execute sp_helpstats ''?'', ''ALL''','?','insert into #Stats select ''?'', * from #Stats_Temp','delete from #Stats_Temp' > > >select * from #StatsBTW, did you see this answer? I was thinking yesterday too after I read the other link I gave you that we can get the information from the sys.Stats view, but I needed to get the syntax right using my original idea too. Took me quite a while to come up with this solution...