monitor-table-change-with-sqltabledependency

monitor-table-change-with-sqltabledependency copied to clipboard

- Fix the trigger "auto-drop" function (the trigger drop needs to be …

5

…the last operation before return) - Fix incorrect WaitForNotifications start that prevent stop to termitate if stoped on application closing (wrong task was waited)

darkag

The assembly is currently not strong name signed. This causes any application using this package to also not be able to sign their assemblies due to the dependency not being...

cslutgen

************* This repo is NOT maintained anymore *************

5

This repo is NOT maintained anymore

christiandelbianco

SqlTableDependency Error Invalid object name 'dbo.dbo_XXX_1a3df6fa-1a3b-4847-adb7-a4b86ca9ff3a_Receiver'

3

I receive very occasionally this error message and sql table dependency stops working. Invalid object name 'dbo.dbo_XXXX_1a3df6fa-1a3b-4847-adb7-a4b86ca9ff3a_Receiver' when I restart windows service it will work fine. Note: Windows service start...

Suresh9sb

Any plans to use Microsoft.Data.SqlClient?

4

Microsoft is providing a new package for SQLclient types https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/ By any chance, is there any plans to use the new NuGet package? Thanks

spareilleux

The brackets are required if you use keywords or special chars (especially space]in the table names or identifiers.

TomSyk

I really appreciate the SqlTableDependency tool. During its use, we ran into issues where a deadlock would occur and the **SqlTableDependency** would enter into a **Stopped** state. We tried restarting...

DuckScapePhilip

TableDependency.SqlClient.Exceptions.UserWithNoPermissionException:“User without permissions.”

3

Application: .net core 3.1, OS:win 10, VS :2019, SqlTableDependency:8.5.8 Sql Server :10.50.1600.1. this is my test code: ``` internal class Program { private static string _con = "data source=.; initial...

JohnnyZhang0628

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.

1

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...

ItsKhuramShahzad

Hello Cristian. I have been using SqlTableDependency with Web Service for some time. For the second time I get an error with the message: Source spid32s Message The activated proc...

pmout