Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149

    Unanswered: Linked Server - Error

    Hi all-

    I created a another SQL Server as linked and I use them in some of my UDFs and SPs. Earlier these functions worked. But this morning, when I try to alter the definitions of these objects or query them, I get the following error message,
    "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."

    Iadded SET ANSI_WARNINGS ON , but I still get this error. Any ideas?

    - CB

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    Thanks Snail. It worked.

    - CB

Posting Permissions

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