Insert Data into a Remote server (SQL) from with in SQL server

January 3, 2011 Written by @bhilash MSSQL Server

It is one of the most useful and powerful feature of SQL server.,to access an external server from residing server

steps :

1. create a linked server

2. say server =

SELECT * FROM .[db_name].[db_owner].[table_name]

3. To insert data in to table1 on db1 with owner dbo of structure as below

create table dbo.table1

(

c_id int,

c_name varchar(100)

)

insert into .[db1].[dbo].[table1] values(1,’name’)

You may also Interested in