I think so in this style it would work but I have no idea with dynamic SQL can anyone help me here?

What is missing in the trigger?

CREATE TRIGGER [dbo].[trg_log_changes_france4]

ON [dbo].[TEST]

FOR INSERT, DELETE, Update

AS

declare @DWDOCID int

declare @DWMODDATE DATETIME

declare @DWPRODUNIT INT

declare @TYPE CHAR(1)

declare @DT_STATUS datetime

declare @PRS_DT_BIRTH

set @DWDOCID = (SELECT DWDOCID FROM inserted)

set @DWMODDATE = (SELECT DWMODDATETIME FROM inserted)

set @DWPRODUNIT = (SELECT PRODUNIT FROM inserted)

IF EXISTS(SELECT * FROM Inserted)

BEGIN

declare @query NVARCHAR(500);

set @query ='INSERT INTO OPENQUERY([VPHIN], 'select dt_status,prs_dt_birth, DS_TYPE,DW_DOC_ID,DW_ARCHIVE, DW_MOD_DATE from owner.T_SI_CHANGED'';

SELECT @DT_STATUS=Getdata(), @PRD_DT_BIRTH=Getdata(), @DS_TYPE='I', @DWDOCID, @DWPRODUNIT, @DWMODDATE FROM Inserted

execute sp_executesql @query

End