Hiding system tables

  • Hi

    I know there is a setting somewhere that allows me to hide the system tables so I only see my database tables in Enterprise Manager, but where is it?

    Thanks for helping.

    Nora

  • Right-click on the server in question -> Edit SQL Server Registration Properties -> Uncheck Show system databases and system objects.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • THANKS!

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

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