Listing 2: Query Showing the Count of Auto-Created Statistics on a Table
SELECT
	object_name(id) TableName
	,count(*) NumberOfAutoStats
FROM
	sysindexes
WHERE
	 OBJECTPROPERTY(id, N'IsUserTable') = 1
	 AND INDEXPROPERTY ( id , name , 'IsAutoStatistics' ) = 1
GROUP BY
	object_name(id)
ORDER BY
	count(*) DESC