Service Broker not working for Restored databases (SQL 2000 databases restored on 2005)

I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased using the query "select is_broker_enabled from sys.databases where name = 'newdbname' " It was 1. I even tried the ALTER DATABASE SET ENABLE_BROKER. but it didnt work.

When i tried the sample on a newly created database it worked fine.

Is there any solution to make the restored database to work for service broker.

Thanks

Prashanth

[825 byte] By [PrashanthHebbar] at [2008-2-17]
# 1

Can you follow the troubloshooting steps from http://blogs.msdn.com/remusrusanu/archive/2005/12/20/506221.aspx and see if you succeed on identifying the cause?

HTH,
~ Remus

RemusRusanu at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 2

Thanks Remus. Actually the link which helped me is the following one.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=97829&SiteID=1

This was answered by you only.

PrashanthHebbar at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...

SQL Server

Site Classified