This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I provide one script to hide all databases for all public login in SQL Server Management Studio.
Generally, we are hiding all databases for security reason.
Using this script you can hide all databases for all user logins.
Once you execute this script, you will not be able to see any databases in SQL Server Management Studio. Only the sysadmin login or owner of the database can see the databases in SQL Server Management Studio.
DENY VIEW ANY DATABASE TO PUBLIC