Hi All,
I would greatly appreciate if you can help with this SQL Syntax error.
I am writing a stored procedure that use an insert statement to insert from a local table to another table on a linked server. The statement i'm writing inside the SP is as follows:
"Insert into [remoteserver.com].remotedatabase.dbo.remotetable(field1, field2) Select field1, field2 from localtable"
When i check the syntex of the SP it give me the following SQL-DMO (ODBC SQLSTate: 42000) error:
"Error 7405: Heterogeneous quireis require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query sementecs. Enable thse options and then reissue your query."
Do you have any idea on how to avoid this error or how to update the emntioned properties.
Thanks,
Wafic