CODEWITHSUNDEEP
sql-server-2005
Manjot
Manjot

Reputation: 11516

TSQL to see when statistics was last updated

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?

Upvotes: 1

Views: 449

Answers (1)

adrianbanks
adrianbanks

Reputation: 82934

Have a look at the STATS_DATE function:

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

Upvotes: 3

Related Questions