Hello World for Service Broker doesnt work

20 Oct 2005 5:59 PM

Bob Zigon

Gang

I am running the Sept CTP of SQL 2005 on Windows 2000 Server with SP4.

When I run the setup and send scripts for Hello World for the Service Broker
... it works just fine when
the db is AdventureWorks.
There is a message in the receiver queue.

But if I create a db called HelloWorldDb and run the setup and send scripts
against it, there
are no messages in the receiver queue. I did edit out the USE ADVENTUREWORKS
statement.

I am including a single .SQL file that will create a db and then try to Peek
at a message in the receiver queue.

Can anyone tell me what I am doing wrong?

Thanks

Bob

[attached file: ServiceBrokerHelloWorld.sql]

20 Oct 2005 6:47 PM

Jerry Spivey

Bob,

See:

http://www.aspfaq.com/sql2005/show.asp?id=1

HTH

Jerry
Show quote

"Bob Zigon" <nospam__robert.zigon@beckman.com> wrote in message
news:ujr72Ba1FHA.1252@TK2MSFTNGP09.phx.gbl...
> Gang
>
> I am running the Sept CTP of SQL 2005 on Windows 2000 Server with SP4.
>
> When I run the setup and send scripts for Hello World for the Service
> Broker
> .. it works just fine when
> the db is AdventureWorks.
> There is a message in the receiver queue.
>
> But if I create a db called HelloWorldDb and run the setup and send
> scripts
> against it, there
> are no messages in the receiver queue. I did edit out the USE
> ADVENTUREWORKS
> statement.
>
> I am including a single .SQL file that will create a db and then try to
> Peek
> at a message in the receiver queue.
>
> Can anyone tell me what I am doing wrong?
>
> Thanks
>
>
> Bob
>
>
>
>