Help with Error 7405 - Heterogeneous queries require the ANSI_NULLS

[dariopowell]

I am trying to write and save a stored procedure but I keep getting the folling error.

Error 7405 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.

The ANSI_NULLS and ANSI_WARNINGS are turned on in the properties on the connections tab for the server in question.

The code does a simple create table and then populates that table from other existing tables. The queary never needs to leave the Server in question and access another server.

NOTE: The query runs fine in Query Analyzer.

Any ideas would be greatly appreciated.

Thanks!!

 

[ESquared]

Don't answer in this thread, since this question was double-posted. Instead, see thread183-861231.