Stored procedure doesn't delete anything from time to time

[harima34]

Hello Christian,

First at all, thank you very much for your NuGet, it's really great.
I've started using it but I have some issue as follows, could you help me to sort it out?
The full stored procedure doesn't delete anything from time to time, even if I execute it manually.

After testing many times, I could only manage to execute it partially with a new query where there is only the code for drop the trigger, then it's removing the trigger :
IF EXISTS (SELECT * FROM sys.triggers WITH (NOLOCK) WHERE object_id = OBJECT_ID(N'[dbo].[tr_dbo_Visits_ae0a0f27-85ed-404a-a578-eb00a5f8da70_Sender]')) DROP TRIGGER [dbo].[tr_dbo_Visits_ae0a0f27-85ed-404a-a578-eb00a5f8da70_Sender];

Do you know where the issue is coming from and how to get rid of it ? (I use the NuGet v8.5.8.)

Thank you very much for your help.
Regards

[tomasfabian]

Hi @harima34,
Christian is hopefully coming back soon...
I had probably the same issue so I tried to fix it. At least it reduces the risk of happening the above mentioned problem.
You can try to convert your code, based on these instructions:
https://github.com/tomasfabian/SqlTableDependency.Extensions/wiki/How-to-convert-from-SqlTableDependency-to-SqlTableDependencyProvider

Please let us know whether it helped.

Regards, Tomas

[harima34]

Hi @tomasfabian , sorry for my late answer, i've checked the link you gave me but im not sure to understand how to do the full process. It's possible to get more explanation about how to do it ? Thank you so much

[tomasfabian]

Hi @harima34, sure it's possible to get more explanation, but I also need more info what exactly is unclear to you. Would it be helpful for you to post an issue "How to convert" in my repository with your current implementation example (code to convert)? You can ask other questions, too.

Regards, Tomas