Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

An Introduction to the Service Broker Expand / Collapse
Author
Message
Posted Wednesday, November 19, 2008 10:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, November 20, 2008 7:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 4:13 AM
Points: 1,860, Visits: 3,597
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 2
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
Posted Wednesday, February 25, 2009 5:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 3, 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
Posted Tuesday, July 14, 2009 8:53 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 14, 2014 12:26 PM
Points: 964, Visits: 956
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
Posted Tuesday, October 5, 2010 2:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase «««1234

Permissions Expand / Collapse