Create Linked server for two different domain servers

• vyelchri

  Ten Centuries

  Points: 1304

  More actions

  April 14, 2010 at 5:27 am

  #220481

  HI,

  I want to pull data from remote server to my local server. Every time i am connecting to that remote machine (the machine where SQL sql server is installed) and copy the data and bringing it to out local database. Instead of that if i can create linked server from our local database to remote database to run the queries easily.

  Can some body plz assist me how to create Linked server to remote servers in sql server 2008 version.

  Any help would be appriciated.

  Thank You,

  Venu Yelchri.

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  April 14, 2010 at 5:36 am

  #1151240

  hi,

  Why dont you write scrpts or Packages for importing data into Ur local machine....

  or

  Go for replication.....

  U r looking into LInked servers only....

  sp_addlinkedserver

  http://msdn.microsoft.com/en-us/library/ms188279.aspx

  http://msdn.microsoft.com/en-us/library/ms190479.aspx

  http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm

  cheers!

  Sasidhar Chowdary

• vyelchri

  Ten Centuries

  Points: 1304

  More actions

  April 14, 2010 at 6:21 am

  #1151267

  Basically, i want to get the rows from remote server to local database and update the local stored procedures in remote database.

  For that reason i have to create a linked server and use it in some automated scripts to achieve the tasks.