USE AdventureWorks2012;

DECLARE @schema_name SYSNAME,

@table_name SYSNAME;

SELECT @schema_name = N'HumanResources',

@table_name = N'Department';

SELECT st.name AS StatsName,

STATS_DATE(st.object_id, st.stats_id) AS [LastUpdated]

FROM sys.objects AS tbl

INNER JOIN sys.stats st ON st.object_id = tbl.object_id

WHERE tbl.name = @table_name

AND SCHEMA_NAME(tbl.schema_id) = @schema_name;