My StoreProcedure Problem

mpolaiah · July 11, 2015, 5:54am

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

graz · July 11, 2015, 10:36am

Please post your code.

bitsmed · July 11, 2015, 11:02pm

As I read the error, you need to set both options to on. And you set one of them to off.