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