MS SQL Server - Cross instance / server joins

Author

Cross instance / server joins

Randy K

2005-09-06, 8:23 pm

We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?

Thank you,
Randy
wawork@hotmail.com

Tom Moreau

2005-09-06, 8:23 pm

Yes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Randy K" <wawork@hotmail.com> wrote in message
news:431dbdc5.2953031@msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?

Thank you,
Randy
wawork@hotmail.com

Sponsored Links