From: siddhath on


All,
I have two databases A and B on one pyhsical box called 'P'. I need to put
another instance of database A on same box. i can not have same database name
twice on same physical box twice so my solution was to create another
instance of sql server on same box and create database A on it. so now it
looks like this.

Physical box P has two DBs
-A and B

New instance of sql server on same physical box P has
- A (copy of DB A )

Both DB's "A on physical box P and A on the new sql server instance" need
to share/join to single copy of B runing on physical box P. Is there a way to
do that without using linked servers?
Thanks
Siddharth

 | 
Pages: 1
Prev: max text repl size
Next: SQL merge setup question