Re: Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Review the information in BOL regarding "set ansi_nulls" - pay special
attention to the information about stored procedures. Then review the notes
for "create procedure" - it reiterates the previous point and adds some
additional information. Then - go fix your procedure. Note that using EM
to do this makes the process that much more difficult, since it tends to
hide important details (like this). Instead, use QA and a script to create
the procedure. Of course, you should be using scripts of some sort since
all code for the database (schema, stored procedures, UDFs, triggers, etc)
are as important to the entire system as your application code.

BTW - you want to set ansi_nulls ON, not OFF. Generally, something that is
"set" means it is set "on".


.

Relevant Pages

  • Re: Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options
    ... attention to the information about stored procedures. ... Then review the ... notes for "create procedure" - it reiterates the previous point and adds ... use QA and a script ...
    (microsoft.public.sqlserver.connect)
  • Re: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)
  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... Puget Sound Oracle Users Groupwww.psoug.org ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: Transfer SQL Server Objects Task not working with Stored Procedures
    ... SQL Server Objects Task is broken. ... Change the MaximumErrorCount or fix the errors. ... My preferred way of transferring stored procedures is to open SSMS/ ... 'script as Create.' ...
    (microsoft.public.sqlserver.dts)