Re: Hide databases in EM/QA

Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
Analyzer, you will find that almost impossible.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


<slousch@xxxxxxxxx> wrote in message
news:1161762813.020209.171520@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a MSSQL 2000 SP4 with ~200 databases of our clients.
Each client can access only his own database, but in Enterprise Manager
he able to view all databases on server.
How can I hide all other databases from client?



.

Relevant Pages

  • Re: From BAD To WORSE: A Disasterous Delete
    ... Enterprise Mangler often does a table shuffle under the covers when making ... You can see exactly what it intends to do by saving the ... I support the Professional Association for SQL Server ... > mysterious deletion of ALL RECORDS, but now with the smaller data extract. ...
    (microsoft.public.sqlserver.server)
  • Re: Alert in Email !!!
    ... locking behavior to the database engine. ... Most good judgment comes from experience. ... machanism in dept in SQL Server but I can see so many definition, ... Check in Books Online about osql/sqlcmd, ...
    (microsoft.public.sqlserver.clients)
  • Re: Alert in Email !!!
    ... locking behavior to the database engine. ... Most good judgment comes from experience. ... machanism in dept in SQL Server but I can see so many definition, ... Check in Books Online about osql/sqlcmd, ...
    (microsoft.public.sqlserver.clients)
  • Re: /3GB switch in 64-bit environment
    ... SQL Server 2005, Standard Edition allows 4 GB memory -if that's of any help. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: From BAD To WORSE: A Disasterous Delete
    ... Tibor Karaszi, SQL Server MVP ... "Geoff N. Hiten" wrote in message ... > Enterprise Mangler often does a table shuffle under the covers when making ...
    (microsoft.public.sqlserver.server)