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.