Mehedi's Earth

In some cases, I used linked server. If you use linked server you might get "Linked Server - Error 7405: Heterogeneous queries" error in stored procedure. A simple resolution is use below code block at the beginning of the stored procedure.

SET ANSI_WARNINGS OFF
GO
SET ANSI_NULLS ON
GO