SQLServerCentral / Administering / SQL Server 2005 / Difference in rowcount with select and Table properties? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:40:57 GMT20RE: Difference in rowcount with select and Table properties?http://www.sqlservercentral.com/Forums/Topic723944-146-1.aspxYou need to update the usage on that database. I would bet anything the database was upgraded from SQL Server 2000 and you have never run an update usage.Wed, 27 May 2009 09:19:05 GMTJeffrey Williams 3188RE: Difference in rowcount with select and Table properties?http://www.sqlservercentral.com/Forums/Topic723944-146-1.aspxDo you have automatic statistics gathering enabled for the offending table?Wed, 27 May 2009 05:56:33 GMTPaulB-TheOneAndOnlyRE: Difference in rowcount with select and Table properties?http://www.sqlservercentral.com/Forums/Topic723944-146-1.aspxHI davidandrews13 its different me for alsowhen i execute select * from [User] it displays 16153rows in right bottom corner of Result GridIf go through the Table propertiesits showing 206658plz help me in finding the reason for the difference..Wed, 27 May 2009 05:55:05 GMTningaraju.nRE: Difference in rowcount with select and Table properties?http://www.sqlservercentral.com/Forums/Topic723944-146-1.aspxthey match for me.not sure why they differ for you.Wed, 27 May 2009 05:13:47 GMTdavidandrews13Difference in rowcount with select and Table properties?http://www.sqlservercentral.com/Forums/Topic723944-146-1.aspxHi,I have observe that, when I run a query using select * from tablename it returns say 7800 rows and when i check table properties --> General --> Storage --> Row count displays 8600 rows............. why is this differing in numbers.if you run any huge table u can see this differnce.If any one have any idea on this.Thanks,RajWed, 27 May 2009 04:43:40 GMTdraj108