codecorner.tigernews.co.uk

     from TIGER COMPUTER SERVICES LTD
Top Right Logo Spacer
site copyright 2000-2012
     SQL Server Track C# (C Sharp) TrackData Access TrackPocket PC Track
About the SQL Server track Tips and tricks - get the most from SQL Server Generic Database Access - MDB, SQL Server 2000 and SQL CE

Hiding system tables and stored procedures

It took me some time to find the option to hide system tables and stored procedures in SQL Server Enterprise Manager. I know quite a few other general developers working with SQL Server 2000 who didn't know this option existed either. So here are the simple steps to hide those pesky system objects from SQL Server Enterprise Manager

SQL2000 Edit Registration Properties

Step 1

Highlight the server in SQL Server Enterprise Manager (I've hidden my PC name), right click and select Edit SQL Server Registration properties... from the pop-up menu.

SQL 2000 Registered SQL Server Properties

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.


Home