Post reply

is there away not not see system objects when working in EM

  • July 26, 2005 at 1:38 pm

    #102663

    example, when I go to table in a db, i do not want to see all the system , tables only user tables. thanks

  • July 26, 2005 at 2:09 pm

    #577303

    Sure, but it means modifying how you have the server registered. Do the following:

    1) In EM, right-click on the Server.

    2) Choose Edit SQL Server Registration Properties... from the pop-up menu.

    3) Uncheck Show system databases and system objects.

    4) Click OK.

    That should hide the system objects.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply