Share
Report
957Trying to build a SmartList that includes data from a linked server. While configuring the view in smartlist builder I am getting 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.
I have tried several options based on several posts dealing with this same problem 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?
Thanks
Ajit
*This post is locked for comments
All responses (
Answers (
