Some times you may need to see the system tables or system stored procedures/views or may want to hide it so that only user created objects will be visible.
Follow these Steps...
In the SQL Server Enterprise Manager,
- Right-click the server node under "SQL Server Group" (Say Local)
- Select "Edit SQL Server Registration properties..."
- Check/UnCheck "Show system databases and system objects"
- Click Ok, thats it Done.
This will work for SQL Server 7.0 and SQL Server 2000.
