Источник:
http://www.crankturner.com/2008/09/h...counts-in.html
==============
Our Dynamics AX database is getting bigger - that means business is active and that is usually a good thing :) We use SQLServer as the back-end database server. Here is a trick that will count all of the rows in all of the Axapta tables in about 1 second. This trick will only run on SQLServer (all versions 2000 - 2008).
Here is a query that will return the row counts of every table in your Dynamics AX database.
<blockquote>
USE Axapta
go
<font face="Courier">
select so.name as Table_Name
,rows
from sysindexes si
inner join
sysobjects so
on si.id = so.id
where so.type = 'u'
and indid