redho home | products | services

Programming Forums


Community for Java, PHP, Perl C, ASP and Python programmers
Friday 14 December 2018 00:35

Ask your IT question here

hide system tables in SQL Server's Enterprise Manager



 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Programming Forums -> ASP in depth
View previous topic :: View next topic  
Author Message
Andy
Guest Programmer




How do I hide system tables in SQL Server's Enterprise Manager?
Reply with quote
 
Asp
Guest Programmer




Many people don't like the clutter provided so graciously by the existence of all the system tables, objects and stored procedures in SQL Server's user interface. To get rid of the system objects, just right-click the server in question (in MMC), choose "Edit SQL Server Registration properties...", and uncheck "Show system databases and system objects" ... hit OK and that clutter should disappear, making direct manipulation of your data much easier. This will work in both SQL Server 7.0 and SQL Server 2000.

In SQL Server 2005's new tool called Management Studio, go to Tools / Options / Environment / General and choose "Hide system objects in Object Explorer." Unlike Enterprise Manager, where this setting takes effect immediately, you will need to restart Management Studio to get rid of the clutter.

Reply with quote
 
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Programming Forums -> ASP in depth


Dubai Forums - Expat Help | Vegan Forum | Java Programming | 3d Design Resources | 3d Forum | 3D Jobs | 3D Textures | Paris Forum | Europe Forum
Dubai Classifieds | Dubai Property | Jobs in Dubai | Free London Classifieds | Jobs in London UK

High Quality, Custom 3d animation and Web Design solutions Royal Quality Web Hosting Services Vegetarian and Animal Rights news

© 2018 RedHo