MS SQL Server - Wrong Rows count

Author

Wrong Rows count

Islamegy®

2006-02-18, 9:23 am

I have a problem with SQL Server 2000 enterprise manager.. I truncated a
table and it's now empty but when i see the properties of this table it say
Rows :28..
Where is this 28 Rows.. i don't now.
Before i delete all rows there was it was say 19682 rows while when i run
Select Coun(*) The result is 19554!!

Is this normal behavior??

Tibor Karaszi

2006-02-18, 9:23 am

> Is this normal behavior??

Yes. Read about the DBCC UPDATEUSAGE command in Books Online.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Islamegy®" < NULL_Islamegy_NULL@y
ahoo.com> wrote in message
news:ePOAYdJNGHA.3960@TK2MSFTNGP09.phx.gbl...
>I have a problem with SQL Server 2000 enterprise manager.. I truncated a table and it's now empty
>but when i see the properties of this table it say Rows :28..
> Where is this 28 Rows.. i don't now.
> Before i delete all rows there was it was say 19682 rows while when i run Select Coun(*) The
> result is 19554!!
>
> Is this normal behavior??
>

Sponsored Links