InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:39:02 GMT20http://www.sqlservercentral.com/Forums/Topic1211434-2866-1.aspxHi,See if this is something along your lines of DBA information/metadata also. You may be able to use/share the code.OliverFri, 25 Nov 2011 06:49:28 GMTOliver Woottonhttp://www.sqlservercentral.com/Forums/Topic1211434-2866-1.aspxThere is faster way how to determine total number of rows in table, then in all tables as well. If you have primary key on your table (so it doesn't works that simply for heap tables) you can just simply select rowcnt column on sysindexes where id = objectid('yourtable') and indid = 1.This gives you number of rows in your primary key, which is the number of rows in your table. Subsequently if all tables in your database has a PK, just simply sum all rowcnt columns in sysindexes table.JanThu, 24 Nov 2011 02:17:22 GMTjtruemanhttp://www.sqlservercentral.com/Forums/Topic1211434-2866-1.aspxThanks for sharing.Wed, 23 Nov 2011 21:57:41 GMTHardy21http://www.sqlservercentral.com/Forums/Topic1211434-2866-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Administration/74888/">Total Database Information At Your Fingertips Part - II</A>[/B]Wed, 23 Nov 2011 21:57:10 GMTRahul The Dba