Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for

[rmiao]

Tried put following in beginning of your script?

SET ANSI_NULLS ON;

SET ANSI_WARNINGS ON;