Hi,

First of all check how many rows in your table :-

1) USE THE BELOW MENTIONED QUERY FOR IT :

Select count(*)  from table

if you got the output then analyse how many rows are returned to you when you are using the query :

2)  select * from table.

Another alternative of it that you can copy all the records into a temp table using query :

select * into #temp_1 from table

this query will create a temp table with name #temp_1 and then copy all the records into it.

Then use the following query :

Select * from #temp_1

if it shows all the records to you it means the structure or internal links of your table is broken

then you can truncate your main table .

and create a new one form the #temp_1 to load your data.

if you want any help then i am there in between 6.pm to 11 pm at IST.

Thanks & Regards

Amit Gupta..

MCDBA