–هذا السكريبت منقول من موقع SqlServerCentral
SELECT object_name (i.id) TableName, rows as RowCnt
FROM sysindexes i INNER JOIN sysObjects o ON (o.id = i.id AND o.xType = ‘U’)
WHERE indid < 2
ORDER BY TableName
–******************
–Undocumented procedure “sp_MSforeachtable”
CREATE TABLE #temp (TableName VARCHAR (255), RowCnt INT)
