Steve Jones - SSC Editor (9/26/2016)
Updated the question to say ANSI_NULLS set to ON.
Note, at some point, this will be the only setting allowed.
Thanks, Steve! While I think it's fair* to assume deprecated features are not used unless explicitly stated, it's always best if the question is clear.
For reference on deprecated features: https://msdn.microsoft.com/en-us/library/ms143729.aspx
(Personally, I'm a little disappointed that SET ANSI_NULLS OFF, SET ANSI_PADDING OFF, and SET CONCAT_NULL_YIELDS_NULL OFF are still supported in SQL 2016, let alone the next version.)
*Fair in terms of a QotD - in real-world work, always check!