Sql server management studio 2008: what permissions are necessary to display table list?

Posted by Joel on Stack Overflow See other posts from Stack Overflow or by Joel
Published on 2010-03-11T18:42:19Z Indexed on 2010/03/11 18:44 UTC
Read the original article Hit count: 240

Filed under:

sql-server-management-stu

In SSMS 2008, when I expand the tables folder, all i see is the "System Tables" folder.

In SSMS 2005, when I connect to the exact same database with same account, I expand the tables folder and see all my tables. Has something changed with which tables are displayed by default? Does it only show tables in the default schema by default?

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

as seen on Stack Overflow - Search for 'Stack Overflow'
I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have… >>> More
SQL SERVER – Generate Report for Index Physical Statistics – SSMS

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database… >>> More
SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2008 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More

Developer IT

Sql server management studio 2008: what permissions are necessary to display table list? - Developer IT

Sql server management studio 2008: what permissions are necessary to display table list?

sql-server-management-stu

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

Categories cloud