Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Heterogeneous queries problem

Author  Topic  Nickolas Starting Member 1 Post Posted - 2004-06-18 : 04:29:42 Hullo. Could anybody help me with a little quandary like this? I'm developing a stored procedure that reads data from Excel file into a temp table, checks for errors and updates DB table. To do it I use CURSOR based on SELECT OPENDATASOURCE statement for reading and putting correctly formatted data into a temp table having the same structure as a target table. After this a number of SELECTs testing temp table data for coding and logic errors run and filtered data update the target table. TSQL code normally completes each time I run it from Query Analyzer but results in a Msg 7405 "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection...." when I'm trying to EXEC it as a stored procedure. Setting this options using Enterprise Manager interface (Server-Properties-Connection) doesn't help. My environment: Windows 2000, SQL Server 2000/SP4