"Error 7405: Heterogeneous queries require that the ansi nulls and ansi warnings options be set for this connection"
When I look at both the linked server and the host server the default properties are ANSI_Nulls on. I am trying to insert a row into the linked server table. I have even tried ( Set ANSI_NUlls ON ) in the stored procedure. I may not have the syntax correct. Does anyone know the solution to this?

Joel