• If you use versions prior to 2005, you need to use dbcc updateusage to get accurate count

    http://beyondrelational.com/blogs/madhivanan/archive/2007/11/02/different-ways-to-count-rows-from-a-table.aspx


    Madhivanan

    Failing to plan is Planning to fail