tag:blogger.com,1999:blog-6357505892638015674.post6188658939622156536..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: List out all tables and row count in sql serverUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6357505892638015674.post-83537276722482713012013-06-27T02:45:45.248-07:002013-06-27T02:45:45.248-07:00solution for the duplicate 0-records:
add "w...solution for the duplicate 0-records:<br /><br />add "where a.name like 'PK_%'" at the end of the query.<br /><br />this works if each table ha a self-generated primary key.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-14554205261286866882013-06-13T05:28:51.744-07:002013-06-13T05:28:51.744-07:00The only stmt missing is that the query has to be ...The only stmt missing is that the query has to be run on the database where the row count information is being requested; running it from master will produce a different dataset than running it from AdventureWorks.<br /><br />The second query, requesting the catalog or database name does not work across DBs.Wm. Dexter Joneshttp://www.vendaetta.comnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-79269909195644797292013-02-19T07:03:56.995-08:002013-02-19T07:03:56.995-08:00Works perfect, thanks buddy.Works perfect, thanks buddy.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-55027941431899906532011-06-24T07:03:43.874-07:002011-06-24T07:03:43.874-07:00Just what I needed. Thank you!Just what I needed. Thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-16247602492883661902011-05-04T09:02:49.201-07:002011-05-04T09:02:49.201-07:00And idea on the duplication of tables (as mentione...And idea on the duplication of tables (as mentioned by 'anonymous')? <br /><br />RichMEhttps://www.blogger.com/profile/11531087131086424151noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-6375716424862627742010-06-18T10:11:56.981-07:002010-06-18T10:11:56.981-07:00Excellent Work. Works Perfect.
Thanks buddy.Excellent Work. Works Perfect.<br />Thanks buddy.Prakashhttps://www.blogger.com/profile/15695008295546832036noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-20144680279401259182010-04-13T11:14:27.755-07:002010-04-13T11:14:27.755-07:00Venkat,
The query to display the record counts fo...Venkat,<br /><br />The query to display the record counts for all tables returns duplicate table names, one with 0 records and another with actual count.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-19767923682208397902010-02-27T03:16:02.823-08:002010-02-27T03:16:02.823-08:00Very good work Venkatesan...
I have to build a r...Very good work Venkatesan... <br /><br />I have to build a report for my client that does a row count for all tables in all databases, so instead of running this manually for each databases, is there a way to do this with one routine?<br /><br />PaulPaul O'Toolehttps://www.blogger.com/profile/12405169313648621127noreply@blogger.com