Its for single record I have 10 million records in table.

and space betwwen two values is not fixed .

somewhre its 3 to 10

Hi,

I this is the last detached mdf file i have.

Is it repairable by any tool or any other way.

Thanks.

For above Query The error looks like.

I am trying since last 3 days so my error log has 2124 errors ,i cant post that much here.

Msg 8909, Level 16, State...

Hi,

the most appered error is the one i posted some time ago.

I am getting diffrent errors as i am querying diffrent things on it.

Thanks,

Swapnil.

Hi,

I don't have backup.

This is the first error i got while attaching.

But i can expand and view anything in database object explorer.only tables columns and indexes r not visible.

Thanks.

No,

For Select query its giving the error:

Msg 824, Level 24, State 2, Line 1

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:515235; actual 0:0). It occurred during...