These are connections settings that can be configured with the SET command. Check out SET ANSI_NULLS and SET ANSI_WARNINGS in the BOL.

-Mike

>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