could not open FCB...

I have a DB with 4 tables with errors.
If I do a SELECT count(*) on this tables, works ok
but if I do a SELECT * on this tables, the following
message appears:
Could not open FCB for invalid file ID 0 in database
I tried to drop the indexes ... no problem
I tried to create the indexes .. don't work the same error
appears.
Can I fix the problem ?
ThanksSounds like the indexes are OK, but the data table is corrupt... Run DBCC
checktable on the table... you may have to restore from the last known good
backup...
You may need to open a call to MS (FCB stands for File Control Block I
beleive)
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corp (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Pablo" <ppastormerlo@.lpa.com.ar> wrote in message
news:091e01c36bf4$cd0895b0$a001280a@.phx.gbl...
> I have a DB with 4 tables with errors.
> If I do a SELECT count(*) on this tables, works ok
> but if I do a SELECT * on this tables, the following
> message appears:
> Could not open FCB for invalid file ID 0 in database
> I tried to drop the indexes ... no problem
> I tried to create the indexes .. don't work the same error
> appears.
> Can I fix the problem ?
> Thanks