Boa tarde senhore(a)s,
Esta eu hoje estudando e rodando o comando para visualizar informações de stats e me retornando: Msg 208, Level 16, State 1, Line 2
Invalid object name ‘sys.dm_db_stats_properties’
Fui pesquisar e vejam:
Cenário:
SELECT
obj.name, obj.object_id, stat.name, stat.stats_id, last_updated, modification_counter
FROM sys.objects AS obj
JOIN sys.stats stat ON stat.object_id = obj.object_id
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE modification_counter > 1000;
Msg 208, Level 16, State 1, Line 2
Invalid object name ‘sys.dm_db_stats_properties’
—>The dynamic management object, sys.dm_db_stats_properties, is available in SQL Server 2012 starting with Service Pack 1 and in SQL Server 2008 R2 starting with Service Pack 2.
Fonte:http://technet.microsoft.com/en-us/library/jj553546.aspx
Atualizando SP do SQL 2012, ficou tudo lindo.