Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Service Broker / May 2006

Tip: Looking for answers? Try searching our database.

sample broker example

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
news.microsoft.com - 03 May 2006 19:50 GMT
Hi

I try to set up the helloworld service broker example from SQL Server on my
computer.  when I ran the example as default, everything is working fine.
but when I try to set up the same example on another database besides
adventurework, it did nothing.  there was nothing send to the targetqueue
when I ran the script.  all I did was change the script to use another
database instead of adventurework.  is there something else I have to do
that's not include in the sample.

thanks

Pauli
Remus Rusanu [MSFT] - 03 May 2006 23:57 GMT
For troubleshooting, try to follow the steps from here:
http://blogs.msdn.com/remusrusanu/archive/2005/12/20/506221.aspx
Also, see this post:
http://www.sqljunkies.com/WebLog/ktegels/archive/2006/03/08/18625.aspx

If I'd have to guess, I'd say you don't have a database master key:
http://msdn2.microsoft.com/en-us/library/ms174382(SQL.90).aspx

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

> Hi
>
[quoted text clipped - 9 lines]
>
> Pauli
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.