Default and Named Instances: Can they share a DB?

Last Post 18 Jun 2007 05:19 AM by Lee-Z2. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

07 Jun 2007 12:06 PM
I'm new at this instance business. From reading the articles on the internet, I understand the concept of instances. However, I'm still not sure if I have a default instance and a named instance, I can share a database. Can I share a database with two instances of SQL server?

New Member
New Member

18 Jun 2007 05:19 AM
in this aspect you can regard both instances as separate servers. They can't share a table directly, but you can connect from one server/instance to the other, for instance with "linked server", to access a table in the other instance....

Acceptable Use Policy