I want to run a select between 2 databases.
(I this case they are both SQL server but I have seen the same thing using FOX with SQL data.)
When I run the query in the query analyzer everything goes according to plan. When I try to run as a stored procedure I get the message that Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection.
Can anyone tell me how / where I would do this?
Thanks in advance
Chris