SQL Server 2008 R2

Jan 5, 2016 at 11:33 AM
Edited Jan 5, 2016 at 1:40 PM
Is Table Dependency working with SQL Server 2008 R2 too?

I downloaded the wpf example and replaced both dlls with the new ones (v4.5.1.3).
I got the following errot:
[...] Incorrect syntax near 'POISON_MESSAGE_HANDLING'. [...]

See full image here:
Image

I'm stupid :P ... found out that we use SQL Server 2008 (not R2) and the plain version of 2008 can not create a query with 'POISON_MESSAGE_HANDLING'...

Thanks
Coolzer0
Marked as answer by Coolzer0 on 1/5/2016 at 5:40 AM
Jan 5, 2016 at 7:53 PM
Hi Coolzer0...

So you solve the problem by yourself.
:)
Jan 8, 2016 at 5:53 PM
It is already working on local sql server 2012 express

when I am using remote sql server 2008 R2 express with service broker enabled .
this what i get , any help is appreciated




Image
Jan 10, 2016 at 9:55 AM
HELLO,

I found the problem: SqlTableDependency is using THROW statements that is available only starting from Sql Server 2012.
I changed T-SQL code generated from SqlTableDependency, in order to use RAISERROR (available from Sql Server 7.0).

So, update you SqlTableDependency package (https://www.nuget.org/packages/SqlTableDependency/) and let me know if all works correctly.

Regards.
Jan 10, 2016 at 6:02 PM
Amazing.
Thanks , Christian
It works after updating.
Now this is what i wanted . I don't know how to thank you , it made my life a alot easier.

Thanks Again