Multiple instances of SQL Server

  • I Know you can run multiple instances of SQL Server on the same machine, but can you run one instance accessing a single database on one machine and another instance accessing the same database on a different machine?

    What would be the effect of the above circumstance?

    Jim

  • Do you mean as a linked server?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • NO. Not as a linked server. Just two instances running on two different machines in a domain accessing the same database.

    Jim

  • So, if I correctly understood, you want to write data to a single DB from 2 diferent machines at once ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply