I need help with a trigger that uses a Linked Server Connection

[rarubio1]

I have written a trigger that uses a Linked Server connection, but when it executes it gives me the following error message "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."
I do not know how to set the ANSI_NULLS and ANSI_WARNINGS, please help!

The following is the syntax of the trigger I have written:

INSERT LinkedSrvr.Scheduling.dbo.tblPartNumbers(fkPartNumberID,fkCustomerID,fkAlloyID,Description,Price,Units,ManufWeight)
SELECT S.InvtID,S.ProdMgrID,S.MaterialType,S.Descr,S.StkBasePrc,S.StkUnit,A.StdGrossWt
FROM Inserted S, InventoryADG A
WHERE S.InvtID = A.InvtID
AND S.S4Future10 = 1


Thanks,
RR

 

[SqlHunter]

Set both this values to ON before the insert statement and then at the end turn it off

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON

Both ANSI_NULLS and ANSI_WARNINGS is for controlling the NULL Behaviour