Get record count for a all databases

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

  • 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 AS "Table Name", i.rowcnt AS "Row Count"

    ????????????FROM sysobjects o, sysindexes i

    ???????? WHERE =

    ???????????? 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 1 (of 1 total)

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