Download: Download snippet as check_alldatabase_statsdate.sql.
Copy snippet: For this you need a free my code stock.com 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 select ''dbname'' = db_name(), ''tabname'' = o.name, ''xtype'' = o.xtype, ''idxname'' = i.name, ''stats'' = stats_date(i.id,i.indid), ''rowcnt'' = i.rowcnt, ''dpages'' = i.dpages from sysobjects as o inner join sysindexes as i on o.id = i.id order by o.name ' select * from ##check_alldatabase_statsdate drop table ##check_alldatabase_statsdate
Create a free my code stock.com account now.
my code stok.com 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.