Records disappeared

Hi,
I have lost approximateley 1,000 records from a 1200 record database.
When I check the properties it says 1200 but there are only 200 rcords in
the table.
Help!
John Stevenswhen you click on properties the ROWS details are picked up from the table
sysindexes which may not always show you accurate value. Specifically after
bulk operation.
"Select count(*) from table" will give you the correct result set.
To update the values of sysindexes system table run
DBCC UPDATEUSAGE ... WITH COUNT_ROWS
--
-Vishal
"John Stevens" <yourpal@.mad.co.uk> wrote in message
news:bil1np$6tg$1$8300dec7@.news.demon.co.uk...
> Hi,
> I have lost approximateley 1,000 records from a 1200 record database.
> When I check the properties it says 1200 but there are only 200 rcords in
> the table.
> Help!
> John Stevens
>