Linked Server - Error

• cbarus

  SSCommitted

  Points: 1909

  More actions

  November 24, 2003 at 10:48 am

  #81561

  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

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  November 25, 2003 at 2:23 am

  #483500

  Hi,

  Are you modifying the SP's via EM? If so drop and create the SP with QA it will work if you set the ANSI settings there.

  If it aint broke don't fix it!

  
  Andy.