can you set view to see only user objects in EM

[seminewbee2005]

when I want to not see all the system tables in EM when I am looking at the tables of a user db, I do not want to see the system tables too.

 

[Catadmin]

Drop the Server Registration. When you re-add it, make sure "Show System Databases and System Objects." is unclicked. This will hide all system objects from the users.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[mrdenny]

You don't have to drop the connection. Just edit the properties, and uncheck the "Show System Databases and System Objects". Ofcourse dropping and recreating it will take care of that as well.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)