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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
leohalim
New Member
New Member

--
07 Jun 2007 12: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 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....

You are not authorized to post a reply.

Acceptable Use Policy