Execute the following
SQL Server T-SQL script with four-part addressing in SSMS Query Editor to transfer data
from one linked server to another by appending. SalesOrderDetailID
is automatically generated at target server: