hide system databases sql server management studio I have installed sql server express 2008 and also sql server management studio. I've successfully configured remote connectivity and created a database user and password.
my problem is that in the remote sql server management studio - i want the user to only see the database i assign to them and not see System Databases

I've noticed that the sa login also appears in the folder tree in my remote session which i do not want

How do I go about hiding the system databases as well as logins so that the remote connection only sees logins and database relevant to them
You can hide the system database in SQL Management Studio following Way that I have mentioned below.


  Navigate Tools-->Options-->Environment-->General and choose "Hide
  system objects in Object Explorer".


OR


  In the SQL Server Management Studio, Right click the server and click
  "Properties". Click on "Permissions" and then select the "Public" role
  and remove "Grant" from "View Any Database".


Or You can use 

USE &lt;YourDatabase&gt;

ALTER AUTHORIZATION ON DATABASE::&lt;YourDatabase&gt; to &lt;Login&gt;

USE MASTER

DENY VIEW ANY DATABASE TO &lt;Login&gt;