DROP AUTOGENERATED STATISTICS MSSQL

DECLARE @sm nvarchar(150)

DECLARE merge_cursor CURSOR FAST_FORWARD FOR SELECT (select o.name from sys.objects o where o.object_id=s.object_id)+'.'+name FROM sys.stats s WHERE s.auto_created=1

OPEN merge_cursor

FETCH NEXT FROM merge_cursor INTO @sm

WHILE @@FETCH_STATUS = 0
BEGIN

declare @q nvarchar(1000)
set @q='DROP STATISTICS '+@sm
execute sp_executesql @q

FETCH NEXT FROM merge_cursor INTO @sm
END

CLOSE merge_cursor
DEALLOCATE merge_cursor