This is merely a repost from ex-Microsoft employe “jjameson” here
I’m sick of seeing these temporary table and cursor methods when I google this and I seem to be using this quite a bit lately. Here’s the query:
Also note that 2012 RC0 is available and its got some cool features.
SELECT sysobjects.Name , sysindexes.ROWS FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id WHERE TYPE = 'U' AND sysindexes.IndId < 2 ORDER BY sysobjects.Name
No further explanation necessary…