Fixing SqlDependency Query Notification subscription failure: info="set options" database_id="0" in SQL Server 2012
31 January, 2013
0 Comments
1 category
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