TSQL to see when statistics was last updated

Question

I have SQL 2005 server. I am interested in a particular statistics. I can check its last update time manually by right clicking it.

How can I check it using TSQL?

Answer 1

Have a look at the STATS_DATE function:

Returns the date of the most recent update for statistics on a table or indexed view.