Smartlist Builder, SQL View and a Linked Server

While building a custom Smartlist using a SQL view and Smartlist Builder on a “Linked Server” I ran into an Error.  Ever seen this one before?  I’m sure some of you out there have since it has been around for a while.


Since the ANSI_NULLS and ANSI_WARNINGS are hard coded as Off; consequently, the view created could not connect to the SQL data.

Adding the following to the beginning of the code to turn ANSI_NULLS, QUOTED_IDENTIFIER and ANSI_WARNINGS on…


And add to the end of your code


Corrected the issue.

Leave a Reply

Your email address will not be published.