Hiding system tables and stored procedures in SQL Enterprise Manager

This may be something you all know, but I keep coming across developers who don't know that it is really easy to hide system tables and stored procedures in SQL Server Enterprise Manager.

Step 1 - Highlight the server in SQL Server Enterprise Manager, right click and select Edit SQL Server Registration properties... from the pop-up menu.

Step 2 - In the Registered SQL Server Properties dialogue box, remove the tick from Show system databases and system objects. This will only hide the system objects for that specific SQL Server. You must do this for each SQL Server you have registered in SQL Server Enterprise Manager.

Full details with images at codecorner.tigernews.co.uk.

Print | posted on Wednesday, August 10, 2005 10:08 AM

Comments on this post

No comments posted yet.

Your comment:

 (will show your gravatar)