Get record count for a all databases

• Mr. SQL

  SSC Veteran

  Points: 215

  More actions

  August 3, 2008 at 5:09 pm

  #210797

  Comments posted to this topic are about the item Get record count for a all databases

• linda.russell

  SSC Rookie

  Points: 30

  More actions

  October 23, 2013 at 7:35 am

  #1660924

  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