Hello Mike -

No error message when trying to access table. If running a query from the query analyzer, after issuing the run command nothing happens - Clicking on the 'stop' button results in the following message: "Query cancelled by User
[Microsoft][ODBC SQL Server Driver]Operation canceled"

Right after my original post, I came up with some new info:
I used DTS to try and replicate the table in another DB. Watching the DTS messages, I could see that the new table had been created in the new DB, but it was stuck on '0 records transfered'. Clicking on cancel resulted in locking of Enterprise Manager, (and eventualy ctrl-alt-delete to end task). I decided to try it one more time, and instead of clicking on Cancel when it got hung up, I went into Current Activity in the Enterprise Manager and killed the DTS process. When I switched back to the DTS screen, it had completed with 6 records transfered. Hrmm... I then selected * from new table, and all 6 records were correctly displayed. Using the id from one of these records, I selected the same record from the old table, and it correctly displayed the record.

The ID field is an identity column, so I queried the old table for all records with ID less than the max ID returned from the new table. It returned 87 records. Enterprise Manager properties for the table in question says that the table has 88 records. So I can pull everything except that last record. And if I try to pull *, which includes that last record, everything hangs (no error messages, just sits and spins).

So I can now pull 87 of 88 records from the table, but if I try *any* query that references that 88th record in *any* way, (drop, select *, etc.) it freezes. Very wierd.

I now think the last record is corrupt, but have no idea of how to remedy it.

- Kile


>Do you get an error message when you try to access the table? If so, what is it?
>
>-Mike