sharing DBs between 2 instances on same box without linked servers

Discussion in 'microsoft.public.sqlserver.replication' started by siddhath, Jun 25, 2010.

  1. siddhath

    siddhath Guest

    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
     
    siddhath, Jun 25, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.