Hi,
I'm using SQL Server 2000. My query runs fine through Query Analyzer. But if the same query is called thru a stored procedure it gives the following error inspite of setting the ANSI_NULLS and ANSI_WARNINGS on both the servers;
"Server: Msg 7405, Level 16, State 1, Line 1
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."
Can anybody please help me on this.