You can check fragmentation with DBCC SHOWCONTIG().
What happens when you run a query from QA with the results in TEXT mode (NOT grid)?
Also, try using the NOLOCK table hint. maybe you were being blocked by another connection:
SELECT * FROM mytable WITH (NOLOCK)
What does DBCC CHECKTABLE() return?
-Mike
>
It would be helpfull to know what happens when you try to access this table from EM (Open Table, Design Table) and QA (SELECT * FROM ..). Do you get an error or something else? What Sql Server version are you using? Do you've the latest service pack installed?
>>
>
SQL Server 2000 Enterprise Edition (SP2), running on Windows 2000 Server. When I open a table on EM I receive an OLEDB TimeOut Error. QA ran for an hour and twenty minute before I decided to kill the process. Total records in the table I was trying to access is ~100,000. All the other tables seem to be workig fine as far as I can see.
>
>Corrupted Index?? Heavily fragmented table??
>
>I've already ran a reindex on the database - my next step is running database intregrity check as soon I can get everyone out since it requires single mode use.
>
>Am I on the right path?? Or do you have any other suggestions??
>
>TIA.