SQL Server 2008 Management studio - can't see tables, can run queries

Question

Well, I have a database running on shared hosting and have successfully connected to it. However, i cannot see the database but when i run i.e.

SELECT * FROM Item

Item is a table in it, i get correct result.

Further more, when connected via Visual Studio 2010 with the same credentials, i see it.

Yes, i have `View definition` permission and yes, i am connected :) — Bip, May 24 '12 at 09:57
When you open the tables folder do you get an error message or simply not see anything there? — N t, May 24 '12 at 13:05
What do you mean by "cannot see"? Do you mean it doesn't appear in the Object Explorer tree? Or it's not in the dropdown? Can you see some databases but not others? — David Atkinson, May 24 '12 at 21:51
I can not see it in Object Explorer tree but can run queries and create tables... — Bip, May 25 '12 at 00:17

score 1 · Answer 1 · answered May 31 '12 at 16:51

1

Ive had this issue before and resolved it by applying the current Service Pack to SSMS

answered May 31 '12 at 16:51

DarkRiver

tnx. i will try this :) but we've already migrate it to SQL Azure. – Bip May 31 '12 at 19:53

score 0 · Answer 2 · answered Jun 12 '14 at 04:17

0

answered Jun 12 '14 at 04:17

zhongxiao37

2 Answers2