Tables are not visible in SQL Server Management Studio but they are in Visual Studio using same acco
Posted
by Germ
on Stack Overflow
See other posts from Stack Overflow
or by Germ
Published on 2010-04-29T22:19:53Z
Indexed on
2010/04/29
22:57 UTC
Read the original article
Hit count: 385
I'm experiencing a weird problem with a particular SQL login. When I connect to the server in Microsoft SQL Server Management Studio (2008) using this account, I cannot see any of the tables, stored procedures etc. that this account should have access to.
When I connect to the same server within Visual Studio (2008) with the same account everything is there. I've also had a co-worker connect to the server using the same login and he's able to view everything as well.
The strange thing is if I switch logins, I'm able to view objects that the other account has access to which indicates that there isn't a problem with MSSMS on my PC.
Does anyone have any suggestions on how I can diagnose this problem? I've check to make sure I don't have any Table filters etc.
© Stack Overflow or respective owner