RobertB
13th February 2006, 12:08
Does anybody know if changing the ANSI_NULLS and/or ANSI_WARNINGS settings for a MS SQL 7 server hosting the Baan Vc tables will do anything drastic?
I'm trying to construct some distributed queries in SP's on a SQL Server 2000 machine, linked to the SQL 7 server and keep getting the error that 'Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query' Trying to include e.g. 'SET ANSI_NULLS ON' in the SP just leads to a syntax error.
HYCH,
Rob
I'm trying to construct some distributed queries in SP's on a SQL Server 2000 machine, linked to the SQL 7 server and keep getting the error that 'Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query' Trying to include e.g. 'SET ANSI_NULLS ON' in the SP just leads to a syntax error.
HYCH,
Rob