SQLTeam.com | Weblogs | Forums

My StoreProcedure Problem


#1

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


#2

Please post your code.


#3

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