troubleshooting Question

Weird behavior: unable to open or query table named scores, but renaming allows access

Avatar of chriso008
chriso008 asked on
Microsoft SQL Server 2005Microsoft SQL Server
4 Comments1 Solution216 ViewsLast Modified:
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.

Any ideas?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros