An Introduction to the Service Broker

Question

Post reply

An Introduction to the Service Broker

Viewing 5 posts - 31 through 34 (of 34 total)

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

kingshukbagchi SSC Journeyman Points: 98 More actions · Answer 1

This has actually worked for me... have you done "alter database [database name] set enable_broker"?

Kingshuk

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 2

kingshukbagchi (11/19/2008)
This has actually worked for me... have you done "alter database [database name] set enable_broker"?
Kingshuk

yes

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

jaiganesh_paramanantham Newbie Points: 5 More actions · Answer 3

Excellent Article,

I am new to service broker topic, I copied the sample script which you explained in your article. That is not working for me. I send a 'Hello world message. I can't see the message in the queue. Can you confirm is any set up needs to do before running this script?

S. Kusen SSChampion Points: 10936 More actions · Answer 4

Seems like the code did not work for me at first either. as the earlier posts suggested, i enabled the service broker, and then created a master DB key for my DB.

sys.transmission_queue had the following message:

"The session keys for this conversation could not be created or accessed. The database master key is required for this operation."

I then issued this:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''

re-ran the code sample as presented in the article, and it worked.

The WITH ENCRYPTION=OFF should have also worked as another poster suggested.

Steve

NAIROOZ NILAFDEEN Grasshopper Points: 17 More actions · Answer 5

You dont need loop thru..instead u can use an activation sp.