Hide Databases

From: Alex Decarli (anonymous_at_discussions.microsoft.com)
Date: 01/16/04 

Date: Fri, 16 Jan 2004 02:22:07 -0800

Hi Folks,

I´m sharing a SQL Server 2000 SP3a with some users.
These users are using Enterprise Manager and Query
Analyzer at client side. It´s working well.

My problem is: In Enterprise Manager view, users can see
all databases, but only can manipulate your database.

My Question: In SQL Properties, How can I hide Databases
to non-owners ?

Thanks
Alex Decarli.

Relevant Pages

  • Re: Unable to connect to SQL 2000 engine on other machine from SSMS
    ... On the client computer you can connect to the SQL Server 2000 server using Enterprise Manager. ... But when you connect from the client with Management Studio, it will use the network settings from the SQL Server Native Client, and perhaps TCP (or your preferred protocol) is not enabled for your client. ... I'm guessing that Enterprise Manager and Management Studio are attempting different protocols. ...
    (microsoft.public.sqlserver.connect)
  • Re: MYSQL what should I know
    ... MSDE is Microsoft Desktop Engine (I think that's ... size (but you can have many databases in one instance, and you can have up to 16 ... It supports Views, Stored Procedures, everything that SQL Server does. ... supposedly you can buy Enterprise manager and Query analyzer for $75 or so from ...
    (microsoft.public.vb.general.discussion)
  • Re: Hide Databases
    ... This is not possible in SQL2000 Enterprise Manager. ... pretty lax.You can choose to hide System databases if you wish, ... Jasper Smith (SQL Server MVP) ... "Alex Decarli" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Very slow Responding SQL2000
    ... Can you install the SQL Server client tools remotely and connect ... using both Enterprise manager as well as Query ANalyzer and check the Query ... One more thing is uncheck the AUTOCLOSE option for all databases ...
    (microsoft.public.sqlserver.server)
  • Re: Maximum practical number of databases per SQL Server 2000 Instance
    ... Enterprise Manager took 32 seconds to render the screen. ... Mike Epprecht, Microsoft SQL Server MVP ... > We have hundreds of databases on our cluster. ...
    (microsoft.public.sqlserver.server)