An Introduction to the Service Broker

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Srinivas Sampath » An Introduction to the Service Broker

35 posts, Page 4 of 4

«««1 2 3 4

An Introduction to the Service Broker

Rate Topic

Display Mode

Topic Options

Author

Message

kingshukbagchi

Posted Wednesday, November 19, 2008 10:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 12:34 AM
Points: 4, Visits: 16

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

Kingshuk

Post #605569

Marios Philippopoulos

Posted Thursday, November 20, 2008 7:47 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 1,825, Visits: 3,484

kingshukbagchi (11/19/2008)

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

Kingshuk

yes

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation

Post #605825

jaiganesh_paramanantham

Posted Wednesday, February 25, 2009 5:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 03, 2011 3:22 PM
Points: 1, Visits: 17

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?

Post #664138

S. Kusen

Posted Tuesday, July 14, 2009 8:53 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 4:03 PM
Points: 956, Visits: 879

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 = '<password here>'

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

Post #753140

NAIROOZ NILAFDEEN

Posted Tuesday, October 05, 2010 2:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 30, 2011 6:42 AM
Points: 1, Visits: 17

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

Post #998153

« Prev Topic | Next Topic »

35 posts, Page 4 of 4

«««1 2 3 4

Permissions