2005 Managemt. Studio - Objects not appearing in Summary?

[LFCfan]

Okay - I must be being silly here.
SQL Server 2005, SP1

In Object Explorer, if I select Tables, for example, the Summary window shows only the System Tables folder. not the list of User Tables I would be expecting. And selecting the System Tables folder doesn't show the individual system tables either. Ditto Stored Procedures. and I DEFINITELY have some tables and stored procs created in this DB!

What am I missing here? There doesn't seem to be any anything in Tools/Options (except an option to "hide system objects from object explorer" which I have unchecked).

Have I got a dodgy installation or something?

Many thanks

_{~LFCfan
"I learned when I was young that the only true life I had was the life of my brain. But if it's true that the only real life I have is the life of my brain, what sense does it make to hand that brain to somebody for eight hours a day for their particular use on the presumption that at the end of the day they will give it back in an un}

 

[LFCfan]

Okay, they have magically appeared in object explorer now, so ignore me.

I must have been doing something dreadfully stupid, but then that's Fridays for you


_{~LFCfan
"I learned when I was young that the only true life I had was the life of my brain. But if it's true that the only real life I have is the life of my brain, what sense does it make to hand that brain to somebody for eight hours a day for their particular use on the presumption that at the end of the day they will give it back in an un}

 

[mrdenny]

Make sure you don't have a filter specified.

I have on occation seen it not show up anything. Usually clicking to another folder then clicking back will fix it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com