Mar 1, 2006 #1 mohanmsc Programmer Joined Jul 26, 2005 Messages 6 Location IN please help me i want to join two table that are in two different sql servers.
Mar 1, 2006 #2 SQLDenis Programmer Joined Oct 1, 2005 Messages 5,575 Location US you will have to create linked servers lookup linked server in BOL Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/ Upvote 0 Downvote
you will have to create linked servers lookup linked server in BOL Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/
Mar 1, 2006 #3 SQLSister Programmer Joined Jun 18, 2002 Messages 7,292 Location US ANd once you have linked the servers you refer to them using the fourpart name of server.database.owner.Object Questions about posting. See faq183-874 Click here to help with Hurricane Relief Upvote 0 Downvote
ANd once you have linked the servers you refer to them using the fourpart name of server.database.owner.Object Questions about posting. See faq183-874 Click here to help with Hurricane Relief