Set nocount on

DECLARE crComando CURSOR READ_ONLY FOR 
select name from sys.objects where type = 'u' order by name

DECLARE @name varchar(400)
OPEN crComando

FETCH NEXT FROM crComando INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
	IF (@@fetch_status <> -2)
	BEGIN
	
		DECLARE @message varchar(8000)
		SELECT @message = 'SELECT '''+@name +''' as Objeto, STATS_DATE(OBJECT_ID,STATS_ID) StatDate,* FROM SYS.STATS WHERE OBJECT_ID = OBJECT_ID('''+@name +''')' 
		--PRINT @message
		Exec(@message)
		
	END
	FETCH NEXT FROM crComando INTO @name
END

CLOSE crComando
DEALLOCATE crComando

SELECT 
object_schema_name(OBJECT_ID) as SchemaName,
object_name(OBJECT_ID) as Objeto, 
STATS_DATE(OBJECT_ID,STATS_ID) 
StatDate,* 
FROM SYS.STATS 
WHERE OBJECT_ID IN(SELECT object_id from sys.tables)
order by 
  object_schema_name(OBJECT_ID),
  object_name(OBJECT_ID),
  stats_id