hide system tables

12 Aug 2005 3:47 AM

sqlster

How can I hide all the sys tables under tables pane on the right hand side in
enter prize manager.

I would only like to view user created table and not have it clutter up with
all the sys tables.

Please let me know.

TIA...

12 Aug 2005 4:04 AM

GregO

Hello,
That is simply done by Right clicking on the server name in the left havnd
panel and selecting Edit SQl Server Registration properties from the menu.
THen make sure the "Show system database and system objects" is checked off.
(Master, model, msdb & tempdb)

--
kind regards
Greg O
Need to document your databases. Use the firs and still the best AGS SQL
Scribe
http://www.ag-software.com

Note that this will remove the system databases as well

Show quote

"sqlster" <trisha@nospam.nospam> wrote in message
news:FD0B864F-1C70-42F3-B7B0-F872EFD04776@microsoft.com...
> How can I hide all the sys tables under tables pane on the right hand side
> in
> enter prize manager.
>
> I would only like to view user created table and not have it clutter up
> with
> all the sys tables.
>
> Please let me know.
>
> TIA...

12 Aug 2005 4:04 AM

Uri Dimant

sqlster
1.. Right click on the "(Local)(WindowsNT)" in the Enterprise Manager.
2.. Select "Edit Sql Server Registration Properties," which opens up a
property panel.
3.. Uncheck the option "Show system databases and system obejcts."
Show quote

"sqlster" <trisha@nospam.nospam> wrote in message
news:FD0B864F-1C70-42F3-B7B0-F872EFD04776@microsoft.com...
> How can I hide all the sys tables under tables pane on the right hand side
> in
> enter prize manager.
>
> I would only like to view user created table and not have it clutter up
> with
> all the sys tables.
>
> Please let me know.
>
> TIA...