April 4, 2008 at 7:39 am
I have four separate instances running on three separate servers. I would like to retain one database in instance A and create views in instances B, C, & D that displays the data.
I can't get the servers to connect to each other and share this data. The only options that I have had is the Migration Wizard.
These are all SQL Server 2005 Standard.
Any guidance will be appreciated.
April 4, 2008 at 8:08 am
You need to create Linked Servers between the Servers. Then you they can reference each other.
For instance on ServerA you create a Linked Server to ServerB. On ServerA you can then query ServerB using 4 part naming like:
Select columnA From ServerB.DataBase.Schema.Table
This assumes that the account used for linked server access has the appropriate permissions.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 4, 2008 at 8:51 am
I knew it must have a simple solution! Thank you so much. It works perfectly.
April 4, 2008 at 8:57 am
Glad to help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply