Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For some reason 3 tables which are clearly in use by the application are not listed in the Tables view in SQL Server Enterprise Manager. It's SQL Server 2000. When generating a diagram, a popup appears stating that those tables couldn't be loaded. The weird thing is that data from those tables is actually returned in the application (not cache).

share|improve this question

closed as unclear what you're asking by Michael Green, Paul White Apr 23 at 11:19

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Is there anything specific about table names? – Carol Baker West Jan 2 '13 at 11:33
    
As far as I'm concerned not. They are named News, News_Reactions and Gallery. – Abel Jan 2 '13 at 11:39
7  
Any chance the login that you use to connect to the enterprise manager does not have permissions? – WrinkleFree Jan 2 '13 at 11:40
    
Does checkdb run clean on that database? – cfradenburg Jan 2 '13 at 17:51
    
Do you have 2005 or better installed also on this server? – PollusB Jan 8 '13 at 20:47