Default and Named Instances: Can they share a DB?

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

--
07 Jun 2007 01:06 PM
Hi,
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?

Leo
Lee-Z2
New Member
New Member

--
18 Jun 2007 06: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
---