Hello everyone, I have written a stored procedure which selects from
tables in a linked server (using openquery.) The statement runs fine
from Query yzer, but when I past it into a stored procedure, and
the syntax check is fine, but I get this error when I try to Save it:
Error 7405: Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connecton.
This ensures consistent query semantics. Enable these options and then
reissue your query.
I checked ANSI NULLS and ANSI WARNINGS for the server (database
properties->connetion tab) but I still get this result. any ...