Post reply

Get record count for a all databases

  • August 3, 2008 at 5:09 pm

    #210797

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

  • 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

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

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