Re: Not displaying system dbs in EM

From: ME (ME_at_hotmail.com)
Date: 07/07/05 

Date: Thu, 7 Jul 2005 09:41:26 -0700

if you uncheck the box to display system databases and system objects when
you register the server, you don't see system databases.

hth,

"Jean Davis" <jean_davis_200@hotmail.com> wrote in message
news:ewdmQmvgFHA.3296@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I've just run the updated sp_MSdbuseraccess SP so that users can only see
> databases listed in EM that they have access to but does anyone know of a
> way to update this so that the Master, MSDB and tempDB databases are not
> displayed as well?
>
> Thanks - Jean.
>

Relevant Pages

  • Re: Not displaying system dbs in EM
    ... This is so that clients cannot see the system dbs though. ... login I can stop myself from seeing them but how do I stop others from ... you don't see system databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... I plan on giving the Virtual SQL Instance name the same name as my current ... That way the name of the SQL Server will not change. ... Again, copying the system databases, even if successful, won't fix ...
    (microsoft.public.sqlserver.clustering)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... Again, copying the system databases, even if successful, won't fix ... planning a major server migration. ... > virtual SQL Server instance is the same as before. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... SQL virtual server (on shared disk) to different location? ... Regards ... > moving system databases those are master, ...
    (microsoft.public.sqlserver.clustering)
  • RE: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)