my code

Snippet options

Download: Download snippet as check_alldatabase_statsdate.sql.
Copy snippet: For this you need a free my code account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

create table ##check_alldatabase_statsdate (
	dbname nvarchar(256) null,
	tabname sysname null,
	xtype char(2) null,
	idxname sysname null,
	stats datetime null,
	rowcnt bigint null,
	dpages int null

exec sp_MSforeachdb @command1 = '
insert ##check_alldatabase_statsdate
	''dbname'' = db_name(),
	''tabname'' =,
	''xtype'' = o.xtype,
	''idxname'' =, 
	''stats'' = stats_date(,i.indid),
	''rowcnt'' = i.rowcnt,
	''dpages'' = i.dpages
	sysobjects as o 
	inner join 
	sysindexes as i 
	on = 
order by

select * from ##check_alldatabase_statsdate

drop table ##check_alldatabase_statsdate

Create a free my code account now.

my code is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.