Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
Bob
Right-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>
|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
>> Can't seem to find how to hide the tables that start with sys in the
>> tables list. I know it can be done, just can't remember how.
>> Any help greatly appreciated.
>> Bob
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> > Can't seem to find how to hide the tables that start with sys in the
> > tables
> > list. I know it can be done, just can't remember how.
> > Any help greatly appreciated.
> >
> > Bob
> >
> >
>