Re: Two databases, same name, same machine

brinama@compans.com wrote: } } Hi, I hope someone can help, } } What I would like to know is can I run two seperate databases with the } same name on the same machine under Online 5 } Both databases will have exactly the same tables, applications, stored } procs etc, but will hold two distinct sets of data - 2 different } companies. } I wish users to be able to use one database at a time, eg 50 users } using one and 50 using the other at the same time, but no one user } using both at the same time. } Also, any ideas as to how system performance might be affected by } this? } } Any suggestions most welcome. The only way I can think of is 2 separate Online instances. You cannot have 2 databases of the same name in the same instance. Can you not have two different names and supply the database name as an environment variable for your application to connect to ? We do this in 4GL for our systems and ensures that the code does not need to know the database name (we in the DBA can call it anything, it is irrelevant to the developers). -- Rick Ward Senior DBA Great Universal Stores Home Shopping MANCHESTER, UK