Post reply

Hiding System Tables

  • July 14, 2005 at 8:21 am

    #167879

    Hi

    How do you remove the system tables from display in SQL Server Enterprise Manager. As I never use these tables, I was wondering if there is an option that only displays the user created tables?

    Thanks in advance

    Brendan

  • July 14, 2005 at 8:26 am

    #574413

    Right click on the server

    2nd option : Registration properties of a server (rough translation)

    Before the last check box : display system tables.

  • July 14, 2005 at 8:28 am

    #574415

    Remi

    Thanks for the amazing quick reply. Your solution was exactly what I needed.

    Cheers

    Brendan

  • July 14, 2005 at 8:40 am

    #574426

    HTH.

  • July 15, 2005 at 1:45 pm

    #575028

    That's because Remi is either (a) an AnswerBot, (b) a lightly-loaded manager who has nothing better to do than to scan forums and provide good answers, (c) a multi-tasking alien life form with an unknown agenda to subjugate humanity through controlling the databases of the world.

    I'm not entirely sure which. 🙂

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • July 15, 2005 at 7:29 pm

    #575083

    A, b, c and d .

Viewing 6 posts - 1 through 5 (of 5 total)

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