I have run into this problem when adding an linked server (sqlserver) and creating an view based on an openquery i.e
CREATE VIEW vwMyView AS
SELECT * FROM OPENQUERY(MyLinkedServer,'SELECT * FROM MyTable') MyTable
When querying this view i get, i also tested to create an strored procedure with the same result?
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics
Is there any way i can set ANSI_NULLS on|off within the OPENQUERY ?
Has anyone ben facing this?