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