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: 382

Filed under:
|
|
|

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

Related posts about sql-server-2008

Related posts about mssms