|
Alternate Method of obtaining row record count from a table
-----
SELECT SUBSTRING(o.name, 1, 30) as name, i.rows as Number
FROM sysindexes i INNER JOIN sysobjects o
ON i.id = o.id
AND o.type = 'U'
--AND i.name not like '_WA%'
AND i.indid in ('0', '1')
AND o.name <> 'dtproperties'
ORDER by o.name
|