Take the 2-minute tour ×
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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.