I Have a table SalesHistory in one of my development server which shows 96 rows when viewed via EM and sysindexes. but actually there are no rows in that. There is no open transactions, I ran DBCC UPDATEUSAGE(0), UPDATE STATISTICS SalesHistory, restarted the server only to see the same result. what could be the problem??? Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."