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??
