I have used SQL Service broker and SQL Table Dependency and started SQL table dependency in a table for notifications on table data change. I have given all the permission to the database listed in the SQL table Dependency document. After some time, maybe in idle state, it is giving status as "Waiting for notification.
When I change in the table (inserting new record), status is not changing (From waiting for notification) and gives error as
ErrorSystem.Data.SqlClient.SqlException (0x80131904): The conversation handle "1FBDE14B-0A07-EB11-B81C-3CECEF20BFDC" is not found.
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
_sqlTableDependencyOrders = new SqlTableDependency<OrderTrigger>(DBConnection.GetOnlineConnectionString(), "Order");
_sqlTableDependencyOrders.OnChanged += OnDatabaseEventChanged;
_sqlTableDependencyOrders.Start();
User contributions licensed under CC BY-SA 3.0