Is there any way of restricting non-administrative users from seeing the rest of the databases in the MS SQL 2000 Server when logged in through Enterprise Manager? It seems a little strange to me that MS SQL would allow you to see the names of other databases that do not belong to you (even though you do not have access to read them)
You can create another instance. I was told this does not add any more resources. I have actually tested it here at home - created an instance for two databases & it worked flawlessly. Since there were no other DBs under those instances, there was nothing else to see.