SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer

On Random basis, I do get some emails and comments on my blog which makes me do some research and write more blogs to share my thoughts and findings. This blog is an outcome of one such email communication with a user. Let us learn about missing columns in SSMS.

User informed me that they don’t see certain folders in SSMS for system tables. Below is the screenshot (msdb > Tables > System Tables)

SQL SERVER - Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer missing-folder-01

When they check tables under user tables, it was showing all folders.

SQL SERVER - Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer missing-folder-02

WORKAROUND / SOLUTION

If there is any unexpected behavior in SQL Server, always upgrade to the latest version and check. In this scenario, I used the latest version of SQL Server Management Studio, which is freely available for download now. Here is the shortcut link to get to the SSMS download page http://aka.ms/ssms

SQL SERVER - Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer missing-folder-03

Once I download and installed, I connect to same SQL instance and found below.

This reminds me that we should be constantly updating our tools to get maximum return on investment from our product.

Have you found this blog useful? Let me know if you have faced this error before? I would love to hear your opinion.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
Next Post
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?

Related Posts

Leave a Reply

Menu