"INSERT INTO" WITH DIFFERENT SERVER

INSERT INTO dbo.MR_SET_DOCTOR
SELECT SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.doc_serial_no, SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.doc_code, SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.disp_name, SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.employee_serial_no, SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.EDATE, SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.last_modified
FROM SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance LEFT OUTER JOIN
dbo.MR_SET_DOCTOR ON SERVERA.HIMSINDBRWJ0708.dbo.base_doctor_maintenance.doc_serial_no = dbo.MR_SET_DOCTOR.DOCTOR_NO
WHERE (dbo.MR_SET_DOCTOR.DOCTOR_NO IS NULL)

Note :
- Both server must be registered in sysservers table at master database on each server.