We have a SQL Server system with last quarters and this quarters databases, and within each is a table named Scores. We cannot open, query, or browse the Scores table in the current quarter's database. Renaming the table to "Scores1" lets us view the data, but renaming it back to "Scores" makes it fail again. When it fails, we alternatively get a blank window where we expect to see the table data, or we get an error message saying it doesn't exist or isn't available.
It gets more bizarre.. if we rename each of the two databases, effectively swapping the database names, then the problem table stays with the _name_, not the database!
We don't know what caused this, but in the last couple weeks, we've updated firmware and drivers, and SQL Server SP2 update. Event logs don't show anything interesting (to us). DBCC CHECKDB doesn't find anything wrong.
The system is an HP server connected to an HP SAN, running Windows Server 2003 Standard 32-bit, with SQL Server 2005 Standard SP2. The system is internal-use only, and accessed primarily by one programmer. There are no front-end apps, multiple-users.. just the one programmer.