SELECT
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC
Latest technology news.
Thanks for the info.
I like the cod every much as my cms software allows for sql statement execution and I forget the names of tables and columns at times.netflix free 14 day trail
Hmmm, I have never tried the SQL statement you have shared. I was looking for some simple query, but the query you have shared seems complex.<br /><br />---------<br />We are a software testing company find us at http://www.kualitatem.com