Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

hide system objects 2

Status
Not open for further replies.
Niv3k

Niv3k

Programmer
Jul 11, 2001
350
US
Is it possible to hide the system objects(tables, sp's, etc), from the view in Enterprise manager? Just a simple check box or something?

Thanks,
Kevin
 
Sort by date Sort by votes
If you right click on your server, one of the options is to "edit Sql Server registration properties". Pick this option and one of the choices is "show system databases and system objects". Uncheck this choice and the system tables should disappear from your table lists.
 
Upvote 0 Downvote
Yay! I looked all over (the wrong places, obviously) for that sort of option. It makes thing so much cleaner now!

Thanks!
Kevin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G12Consult
  • Locked
  • Question
Query System Versioned Table
Replies
8
Views
395
Olaf Doschke
Olaf Doschke
CarrieRo
  • Locked
  • Question
Hide zero value
Replies
5
Views
176
CarrieRo
CarrieRo
dexeloper
  • Locked
  • Question
System for searching SQL tables and contents of external documents
Replies
2
Views
184
dexeloper
dexeloper
tshad
  • Locked
  • Question
dropdownlist data disapears on jquery hide/show
Replies
2
Views
79
tshad
tshad
UHNSTrust
  • Locked
  • Question
Hide Field contents based on an AD group of user
Replies
3
Views
111
LarrySteele
LarrySteele

Part and Inventory Search

Sponsor

Back
Top