My Storeprocedure Error Problem

• polo.csit

  SSCrazy

  Points: 2574

  More actions

  July 10, 2015 at 11:52 pm

  #398730

  Hi All,

  In My SP

  Msg 7405, Level 16, State 1, Procedure usp_Batch_STDAllFields_MCPHD_Merge, Line 64

  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.

  and i put the SET ANSI_WARNINGS OFF

  again it will came again.how to solve it.please help me

• Joshua Feierman

  SSC Eights!

  Points: 903

  More actions

  July 11, 2015 at 6:45 am

  #1811801

  I believe that error message actually means those settings must be set ON, not OFF. I would try setting them both ON and see what happens.

  Senior DBA - Gateway Ticketing Systems
  Co-Founder - Do It Simply Software

  Follow me at http://sqljosh.com