Fixing SqlDependency Query Notification subscription failure: info="set options" database_id="0" in SQL Server 2012

Registering a query for Query Notification requires the database connection on which the subscription is made to have the correct SET OPTIONS enabled: ANSI_NULLS ON ANSI_PADDING ON ANSI_WARNINGS ON CONCAT_NULL_YIELDS_NULL ON QUOTED_IDENTIFIER ON NUMERIC_ROUNDABORT OFF ARITHABORT ON   In my case the SET OPTION ARITHABORT was set to OFF. When …