Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Hide system tables from view in Enterprise Manager
0 views
Skip to first unread message
TECH
Aug 11, 2004, 1:16:12 PM8/11/04
to
Hello,
in SQL Server 2000 Enterprise manager is there a way to hide system tables
from the tables view? I only need user tables to be displayed, what settings
and where do I have to set?
Thanks,
Steve
Aug 11, 2004, 1:20:43 PM8/11/04
to
TECH wrote:
> Hello,
>
> in SQL Server 2000 Enterprise manager is there a way to hide system
> tables from the tables view? I only need user tables to be displayed,
> what settings and where do I have to set?
> Hello,
>
> in SQL Server 2000 Enterprise manager is there a way to hide system
> tables from the tables view? I only need user tables to be displayed,
> what settings and where do I have to set?
Edit the server registration's properties (right click on the server in EM,
then click 'Edit SQL Server Registration Properties'). Then uncheck the
check box saying 'Show system databases and system objects'.
--
Steve Mayne
TECH
Aug 11, 2004, 1:25:30 PM8/11/04
to
Thanks a lot!
"Steve" <st...@somewhere.invalid.com> wrote in message
news:LzsSc.21497451$Id.35...@news.easynews.com...
0 new messages