ANSI NULL or ANSI WARNINGS error from Dex app

If your Dex app throws the ANSI_NULL or ANSI_WARNING error then you need to include SET ANSI_WARNINGS ON in your stored procedure that your Dex app calls.


It should be the first line in that stored procedure.


The message your users would see from GP is (like):


[Microsoft][SQL Server Native Client 10.0][SQL Server]Heterogenous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for connection.  This ensures consistent query semantics.  Enable these options and then reissue your query.