SmartList Builder using SQL view on linked server

(0) Share

Report

Posted on by irishjamr2

615

Trying to build a SmartList that includes data from a linked server. When I add the view that incorporates that data I get the following error:

[Microsoft][SQL Native Client][SQL Server]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.

There are several posts dealing with this same problem on stored procedures and triggers but couldn't figure out how to adapt those to solve this issue when dealing wtih a SQL view and SLB. How do can I get around this?

*This post is locked for comments