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.
On
It looks like a bug in Microsoft SQL Server Management Studio. See https://connect.microsoft.com/SQLServer/feedback/details/387616/tables-node-does-not-show-all-schemas-in-ssmse-2008
Ive had this issue before and resolved it by applying the current Service Pack to SSMS