Post reply

GUI result set

  • April 27, 2005 at 9:58 am

    #88254

    Not sure if anyone of you have noticed this before But i have seen this happen a few times. If you double click on a table from Enterprise Mgr it shows a diff count and if in QA you do an actual count on this table it shows a different figure. why is that? any thoughts/ideas?

    TIA

  • April 27, 2005 at 10:11 am

    #555311

    EM uses sp_MStablespace which in turns reads from sysindexes whis is not accurate until you update ussage. With QA you get the actual values (Count(*))

    hth

     


    * Noel

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

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