|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
January 22nd, 2003, 02:40 PM
|
|||
|
|||
Hiding the system tables in Enterprise Manager
This is driving me nuts...almost as nuts as never figuring out (if there is a way) to show line numbers when I have to use InterDev!
Anyway, does anyone know how to hide the system tables when viewing tables in Enterprise Manager? I remember a day long ago when they were not showing up, and now they are. It's very annoying when you don't need them. Thanks for any pointers.
__________________
"I'm between quotes right now"
|
|
#2
December 18th, 2003, 03:54 PM
|
|||
|
|||
|
hiding system tables in SQL 2000
URL
the text of the link above is this: 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.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Hiding the system tables in Enterprise Manager |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
