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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stop Displaying System Objects in Enterprise Manager

Status
Not open for further replies.
tapks

tapks

IS-IT--Management
Sep 6, 2001
72
0
0
IN
HI!

Everytime when I click on the Tables of a Database of an SQL Server in the Enterprise Managre it displayes all the tables including the System tables.

Is there any way to stop displaying the system tables.

Pl let me know.

Thanks in advance.

Tap_ks
 
Sort by date Sort by votes
Right click on the server group where u dont want to see the system objects. - Edit sql server registration properties and uncheck the box that says
Show system database and objects.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
119
SaltyTheFrog
SaltyTheFrog
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
86
Auguy
Auguy
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
142
Auguy
Auguy
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top