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’)


abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.

Add comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.