Posted by GTi on 09/29/06 11:38

In MS SQL you can create a database that is run in a seperate instance.

Why and when should a database run on a seperate instance ?
Benefits ?

What is prefered and why?
Two applications have it's own tables.
Appplication A have a set of tables.
Appplication B have a set of tables but also use tables from A
Should it run on different databases (DbA and DbB) and instance?
Or is it ok to let them use the same database (DbAB) ?

[Back to original message]