HelloWorld_CLR not sending messages anymore...........

Hello,

Yesterday I made the HelloWorld_CLR sample work and figured today I would create a simple windows service to immulate its functionality. When this was not working I tried the sample again and it stopped working. I have tried several things and nothing has worked. Has anyone seen this before or have any ideas on how I can get it working again? I even tried removing SQL Server and its samples then reinstalling to give me a clean slate but that did not work. I did not make any changes to the software nor did I make any changes to the database however the sample did so I need to make sure I can fix this incase it happens in development not to mention I need to continue development.

The Client Queue is normally empty but sometimes has a request to two in it. The Server Queue has alot in it that are both Request and an unspecified type or has a URL for a type. I would paste it in but it takes too much space. Please let me know if you have any ideas because I am not sure what else to try.

Bellow is a sample of the output from running this sample.

Connecting to SQL Server instance
Connected to SQL Server instance

Transaction 1 begun
Dialog begun from service (HelloWorldClient) to service (HelloWorldService)
Message sent of type 'Request'
Transaction 1 committed

Transaction 2 begun
Waiting for Response....
No message received - Ending dialog with Error
Transaction 2 committed

Connection closed - exiting

Press Enter to Exit

Thanks,
Scott Allison...

Here is a good article from Remus on diagnosing Service Broker problems:

http://blogs.msdn.com/remusrusanu/archive/2005/12/20/506221.aspx

|||

Hello Rushi,

I checked out the link you sent in your reply. I am not if when he states profiler he means the SQL Server Profiler and I am not familiar with it. I will play with it some but if this will give me the needed information I was wondering if you could tell me more on how to setup the options correctly and how to use it to attach to the local machine.

Thanks,

Scott Allison...

|||

Before using the profiler, you should probably check what's in the transmission queue:

select * from sys.transmission_queue

Other places to look for errors is the Intiator and Target queues.

Rushi