How to copy record from a table in a server to a diffrent server.

Hi all,

I have server1 and server2 having the same tables. I wanna copy tbl1 records in server1 to tbl1 table in server2. How can I accomplish this task?

Thank you in advance,

Use a query. This assumes you have permissions to both servers.

Code Snippet

INSERT INTO tbl1
SELECT
Col1,
Col2,
Col3,
etc
FROM Server2.MyDatabase.dbo.tbl1
WHERE {criteria}