Enterprise Manager Table Properties - Record Count Different??

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  January 5, 2006 at 9:37 am

  #91159

  Hello,

  MSSQL2000/SP4

  I get a different record count when I use Query Analyze (ie: select count(*) from tableX ... and viewing the same tableX using Enterprise Manager's "Table Propoerties ... Rows"??? The numbers are off by a bit???

  Any thoughts as to why there is a difference?

   

   

  Many thanks. Jeff

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  January 5, 2006 at 11:12 am

  #612976

  Hi...

   

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=187731

   

  if that works....

  ---

  Regards,

  Papillon

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 5, 2006 at 3:09 pm

  #613057

  EM is using sysindexes and therefore does not need to be equal. Try executing

  DBCC UPDATEUSAGE (0) on the DB that you are quering and you'll see the numbers match

   

  
  * Noel

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  January 6, 2006 at 7:09 am

  #613207

  EM uses sysindexes ... much quicker than a full table scan ie: select count(*) ... i used the DBCC command with success. Thanks noeld.

   

   

  Many thanks. Jeff