Hi Everyone,
May i know is MS Dynamics SL 2011 Quick Query able to support view which select data from multiple Database Server? Because when i try to do so, it prompt error message as below.
SQL Server Message 7405 prompt : [Microsoft][SQL Server Native Client 11.0][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics.
Regards
Kuan Yi
*This post is locked for comments