Get record count for a all databases

  • Mr. SQL

    SSC Veteran

    Points: 215

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

  • linda.russell

    Grasshopper

    Points: 20

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply