I'm struggling (failing) to activate the Object Change Listener for NAV versions beyond 2009.
I followed the steps described here: https://msdn.microsoft.com/en-us/library/dd568739.aspx
and this works great for my 2009 database.
Following these steps for 2013 R2 however does not result in the changes I was expecting! Also the previous link only specifies 2009, so maybe it is not possible.
In 2009 I see the extra entries in the Service Broker/Queues and Service Broker/Services as described here: https://blogs.msdn.microsoft.com/nav/2011/04/28/about-object-metadata-and-why-i-cant-see-object-changes-in-rtc/
. And if I start an SQL Profiler, I don't see the following entries every second: exec sp_execute 1,@lastKnownTimeStamp=463223
In 2013 R2 I do not see those entries in the Service Broker and I DO see exec sp_execute 1,@lastKnownTimeStamp=463223
. Which leads me to believe that I'm doing something wrong, or I am expecting the wrong things.
Can anyone tell me if I'm doing something wrong or if this is not suppose to work this way in 2013 R2 and further?
Thanks in advance!