Jan 17, 2003 #1 bstacy1 Technical User May 21, 2002 11 0 0 US The following was returned when I ran DBCC Checktable against a table in my database 0 rows affected on 204327 pages My question is, why is the page count so high on a table that contains 0 rows?
The following was returned when I ran DBCC Checktable against a table in my database 0 rows affected on 204327 pages My question is, why is the page count so high on a table that contains 0 rows?
Jan 17, 2003 #2 tlbroadbent MIS Mar 16, 2001 9,982 0 0 US Run one of the following commands in your database and then run DBCC CHECKTABLE. Update Statistics 'YourTableName' Execute sp_updatestats Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm If you want to get the best answer for your question read faq183-874. Upvote 0 Downvote
Run one of the following commands in your database and then run DBCC CHECKTABLE. Update Statistics 'YourTableName' Execute sp_updatestats Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm If you want to get the best answer for your question read faq183-874.