Results 1 to 1 of 1

Thread: Set Ansi_nulls

  1. #1
    Join Date
    Oct 2005
    Posts
    58

    Unanswered: Set Ansi_nulls

    When I use OPENROWSET OR OPENQUERY in a Stored Procedure I get an error:

    "Heterogeneous quieries 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."

    I don't remember what I have to do to get around this. I tried placing:

    SET ANSI_NULLS OFF
    SET ANSI_WARNINGS OFF

    Before and after the Create Procudure... line but I can't remember how to correctly use this. Any suggestions?
    Last edited by asahi; 12-06-05 at 14:18. Reason: Answered in another post in the past by another user

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •