CODEWITHSUNDEEP
sqlsql-serversql-server-2008-r2database-permissions
Bip
Bip

Reputation: 913

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

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.

Upvotes: 2

Views: 5669

Answers (2)

zhongxiao37
zhongxiao37

Reputation: 987

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

Upvotes: 0

DarkRiver
DarkRiver

Reputation: 473

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

Upvotes: 1

Related Questions