Service Broker Part 1: Service Broker Basics

Question

Service Broker Part 1: Service Broker Basics

Klaus Aschenbrenner

SSC Enthusiast

Points: 164
More actions
April 15, 2019 at 12:00 am

#3367924

Comments posted to this topic are about the item Service Broker Part 1: Service Broker Basics

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

hsueh010 SSC Enthusiast Points: 126 More actions · Answer 1

Is there anyway to get the figures loaded back onto the article. It appears that where you're pulling the figures from, the links are all broken and I can't see what your figures are.

Kevin Wood-419472 SSC Veteran Points: 234 More actions · Answer 2

Great article series. Much of the documentation is overly confusing but this is a great tutorial.

The first script that creates the database doesn't enable the service broker so the exercise stops working. To enable it, just add the following:

ALTER DATABASE HelloWorldServiceBroker SET DISABLE_BROKER WITH ROLLBACK IMMEDIATE
go
ALTER DATABASE HelloWorldServiceBroker SET NEW_BROKER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE HelloWorldServiceBroker SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
GO

curtis.gregson SSC Journeyman Points: 76 More actions · Answer 3

I agree... Some of the figures (images) are missing. Can they get re-linked.

Otherwise.... great information!!

yoyodynedata Old Hand Points: 352 More actions · Answer 4

This does not throw any errors but I end up with no messages in the Queues. Let me know if this gets updated please.

Service Broker Part 1: Service Broker Basics

Cookies on SQLServerCentral