Insert Data into a Remote server (SQL) from with in SQL 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’)