Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get record count for a all databases Expand / Collapse
Author
Message
Posted Sunday, August 3, 2008 5:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 8, 2014 9:38 AM
Points: 95, Visits: 98
Comments posted to this topic are about the item Get record count for a all databases
Post #545832
Posted Wednesday, October 23, 2013 7:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 28, 2014 12:50 PM
Points: 1, Visits: 6
thanks for the code Brant, I'm fairly new to SQL was I supposed to change anything to make it work for me specifically? All through the results I get this message for every table:
(1 row(s) affected)
Use [ALXDW] SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"
????????????FROM sysobjects o, sysindexes i
???????? WHERE i.id = o.id
???????????? AND indid IN(0,1)
????????ORDER BY i.rowcnt DESC
????????COMPUTE SUM(i.rowcnt)
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '?'.

the names of my tables appear but I do not get any counts. Help please.

Thanks in advance
Post #1507621
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse