SQL SERVER – System Objects Not Visible in SQL Server Management Studio

There are so many settings in SQL Server Management Studio that it can sometimes make someone nervous. Once of my client sent me email telling that something is not right with their SQL Server 2016 installation. Here is an email which I received:

Hi Pinal,
One of the developer has installed SQL Server 2016 on our development environment. I already had SQL Server 2014 running on the server. I am seeing a strange behavior in SQL Server Management Studio. When I connect from SSMS 2014, I am seeing system views as you can see below.

SQL SERVER - System Objects Not Visible in SQL Server Management Studio sys-missing-01

If I connect to a SAME instance via SQL Server 2016 Management Studio, I don’t see the System view. Actually the same is true of any system object under any node in SSMS.

SQL SERVER - System Objects Not Visible in SQL Server Management Studio sys-missing-02

I am not sure if there is something wrong with our installation or we need to reinstall client tools or SQL Server. Have you seen this earlier? Do you know what might be causing it?

Thanks.
John

On first thought, I felt something was seriously wrong or the client was doing something in his installation that caused the same. Since I had SQL Server 2016 management studio installed, I didn’t see this behavior on my laptop. So next action was to figure out if there is any setting which is hiding system objects. After a lot of searching, I was able to find it out. It is hidden under Tools > Options > Environment > Startup.

SQL SERVER - System Objects Not Visible in SQL Server Management Studio sys-missing-03

“Hide system objects in Object Explorer” is the setting which might cause this. I checked with John and he confirmed that his developer that this was the setting he changed in SSMS of 2016 version to avoid clutter in the object explorer.

Is there any such setting which has caused problem to you?

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

SQL Server, SQL Server Management Studio, System Object
Previous Post
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
Next Post
SQL Server 2016 Management Studio – Warning: SSMS install detected shared components on this machine

Related Posts

1 Comment. Leave new

  • Hi Pinal,

    I have been dowloaded 2016 Developer edition the same thing happening to me after instalation on my location machine.still i am unable to see the system objects etc.

    Reply

Leave a Reply