Good to see you writing after a while buddy!! Keep up the good work!!

Good morning, Marios!! Here is the result of the query:

ServiceQueueContract

//UTILITY/UpdStats/InitiatorServiceUpdStats_InitiatorQueueNULL

//UTILITY/UpdStats/TargetServiceUpdStats_TargetQueue//UTILITY/Contract

http://schemas.microsoft.com/SQL/Notifications/EventNotificationServiceEventNotificationErrorsQueueNULL

http://schemas.microsoft.com/SQL/Notifications/QueryNotificationServiceQueryNotificationErrorsQueueNULL

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic

Any clue, where did I go wrong 🙂

Marios, I've setup the database and ran scripts in the order they appear in supplementary material, but receiving the following error when triggered the job "dba - updStats - ServiceBroker"....

Executed...

It's fantastic !! running likea charm.. Thank you very much bro for sharing us the invaluable script !! 😎

Will this code work on systems where publisher, distribution and subscriber databases have been on individual servers ?

I'm too facing very much similar issue in one of our development servers. Please help me get out of that annoying message. Thanks!!!!

Actually I want to get the transaction/command that is applied last on the subscriber and publisher databases. Can someone help me out. Thanks a ton!! 😎