• if i use this query so i can find out how many rows does our largest SQL Server table contains?

    USE AdventureWorks

    SELECT o.name as [Name], i.rowcnt as [Row Count]

    FROM sysindexes i

    INNER JOIN sysobjects o ON i.id = o.id

    WHERE indid < 2 AND o.xtype = 'U'

    ORDER BY Name

    if we see it today at the day end time so we can find the next day transaction and we can get the approperiate result of daily transaction. we required math daily.

    Whats ur openion?

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]