I saw a posting or read a blog somewhere that mentioned custom WCF transport channels where created for interacting with ServiceBroker. Has anyone read or heard something similar? If so, where can I get them? Thanks. Phil

Hi all I am using internal activation on a queue to process the messages, should an error be encountered I call stored procedure A in the same database to log the error. Part of the processing in stored procedure A is a call to stored procedure B in another database (on the same server), ...

Hello, Has anyone seen this in profiler? I have two brokers on different servers with one of them being the initiator. All messages end up sitting in the initiator's transmission queue. Profiler on the target broker's machine displays this for every attempt to send by the initiator: A corrupt ...

How do you set up the service broker to process an email message, and how do you format that message and send it to the que. Can the service broker alos process an html form from a que. Thanks

Our current project involved into managing NTFS hierarchical folders structured by multi-level customers and associated projects for them. Essentially each folder level represents one level of customer hierarchy or project root. Both have different subfolders and user access rights for them ...

I have two databases (A and B )on the same SQL Server instance. Both have SSB enabled and running fine within themselves. All athorizations are at present set to dbo. Recently I had a requirement to start a dialog and send a message from within data base A to a queue via a service that is in ...

when you move a conversation to a conversation group, that conversation_group has to have been created previously, ie, you cant specify a non-existing conversation_group, right? I ask because I am trying to develop an application where I use optimally one conversation related to many given ...

Are lock hints propagated to the underlying tables of system catolog views? I ask because I often query sys.transmission_queue with nolock, and I wanted to know if this was honoured through out the underlying tables. Secondly, is sys.transmission_queue indexed at all, providing a way to ...

Hi Remus What if I need multiple clients to read (RECEIVE) the same message? Would it be possible? Thanks

Hi Remus What if I need multiple clients to read (RECEIVE) the same message? Would it be possible? Thanks

I was trying to send a message on a different instance in the network using service broker. I have created the endpoint and route both the side. I could see that the messages are in the transmission_queue in the sender side with no error in the status. What could be the reason. I am doing the ...

Hello All,After hitting limitations in the SQL CLR world that bar us from invoking COM objects we are forced to use windows services to read the messages off the Service Broker Queues.Unfortunately we loose the auto activation feature in the Queues, but we can still read messages and perform ...

I've been trying to find examples on how to work with the broker using ADO.Net and haven't found much.

When you begin a dialog, you do so between source and target. A conversation is begun on both source and target, and messages flow between the two. What would cause messages to build up on the source in sys.transmission_queue and not get transmitted to the target, with no error in the ...

" noWrap width="1%" bgColor=#b71c0c>1. Yosi 29 Temmuz 12:19 se?enekleri g?ster G?nderen: "Yosi" <yus...@bizitek.com> - Bu yazar?n yazd??? mesajlar? bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | ?let | Yazd?r | Sadece Mesaj | ...

I am trying to test load balancing between multiple broker service instances. I have set up one sender and two receivers. When I tried sending a lot of messages from the sender, I noticed that all messages were being received by receiver 1 alone. While I am able to communicate between sender ...

Hello Remus,I have implemented Event Notification sample you provided in my logic, but I am perplexed that even though my watched queue does go down, I do not get message in the Event_Collector queue all the time. The Event_Collector queue does stay enabled though. Any thoughts? I guess any ...

Hello Remus,I have implemented Event Notification sample you provided in my logic, but I am perplexed that even though my watched queue does go down, I do not get message in the Event_Collector queue all the time. The Event_Collector queue does stay enabled though. Any thoughts? I guess any ...

I am trying to test load balancing between multiple broker service instances. I have set up one sender and two receivers. When I tried sending a lot of messages from the sender, I noticed that all messages were being received by receiver 1 alone. While I am able to communicate between sender ...

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'm trying to use Service Broker to relate a set of messages together and was trying to use a related conversation group id. From what I can gather (looking at other threads) I can't use this.....Basically, my ideas was.... I have several tables being updated within a database transaction. ...

Hello,We are building a simple distributed application around the service broker where each queue is serviced from a windows service. We have a windows service running constantly as a "listener" on an event queue for each of what we call "request" queues. When a message is ...

Hello again,I have some poison message detection in place, based on the BOL sample. My problem is that after the 5th message retry my queue goes down - that is the fifth retry on any message. In actuallity, the first message is retried 3 times and it is taken off the queue [for real], the ...

Hi,I have written a C# console application that adds a message to a SB queue and a C# stored procedure that reads the message from the queue. I have had so many problems that I'm beginning to doubt the usefulness of this, but that is probably just my frustration speaking. I am stuck on putting ...

Hi,I have written a C# console application that adds a message to a SB queue and a C# stored procedure that reads the message from the queue. I have had so many problems that I'm beginning to doubt the usefulness of this, but that is probably just my frustration speaking. I am stuck on putting ...

Hello again,A.This time I would like to get your input on two ways of getting a message off a queue. Both are samples, but I would like to know more about the implications.This first example (BOL) goes directly to the queue:WAITFOR ( RECEIVE TOP(1) @messageTypeName = ...

Hello,This is info that I am still not certain about and I just need to make sure, my gut feeling is correct:A.When a procedure is triggered upon reception of a message in a queue, what happens when the procedure fails and rolls back?1. Message is left on the Queue.2. is the worker procedure ...

HiI'm having problems with activation. I have a CLR stored procedure that runs fine when run directly (and consumes messages from the queue). When I try to enable activation nothing happens. I've tried different execute as options and looked in the sql server logs and I don't see anything ...

Hello,This is info that I am still not certain about and I just need to make sure, my gut feeling is correct:A.When a procedure is triggered upon reception of a message in a queue, what happens when the procedure fails and rolls back?1. Message is left on the Queue.2. is the worker procedure ...

Hey guysI have another weird looking problemI have a queue with a certain number of messages waiting in it to be processed. When I try and receive a message from this queue, I get back an empty row; no message. However, when I try and select from this queue, I see all the messages in there. ...

I need some assistance with getting service broker to work across servers. I have 2 separate servers and I am trying to send a message from one server to the other. No error is generated when sending the message and I get no records in the transmission queue of the sending server, however the ...

" noWrap width="1%" bgColor=#b71c0c>1. Yosi 29 Temmuz 12:19 se?enekleri g?ster G?nderen: "Yosi" <yus...@bizitek.com> - Bu yazar?n yazd??? mesajlar? bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | ?let | Yazd?r | Sadece Mesaj | ...

Wierd problem hereAs one user, when i select * from sys.conversation_endpoints I can see all (I assume) conversations in all states specifically DO, DI and CDHowever when I change to another user I see only DIWhy is this?If it is a permissions issue what permission do I have to grant to a user ...

Wierd problem hereAs one user, when i select * from sys.conversation_endpoints I can see all (I assume) conversations in all states specifically DO, DI and CDHowever when I change to another user I see only DIWhy is this?If it is a permissions issue what permission do I have to grant to a user ...

What does this error mean? I get this in the transmission_status column of sys.transmission_queue An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.Also, does the number in this message correspond to error 10053 in ...

Hi guys, please see if you can help me with this... I have an activation stored procedure that starts a SQL Agent Job which executes a SSIS package. However when the stored procedure runs it fails with the error EXECUTE permission denied on object 'sp_start_job'. The message queue was created ...

What does this error mean? I get this in the transmission_status column of sys.transmission_queue An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'. Also, does the number in this message correspond to error 10053 in ...

Some months ago I was playing with Service Broker and everything was ok. But now I just can't get it work. I opened a sample "helloworld" project and still cannot get a message in a target queue. No errors, just empty queues. We have two SQL servers sept CTP on different computers ...

I use 2 SQL Server: 1 – SQL Server 2005 Enterprise on Windows Server 2003 (Itanium) and SQL Server Express on Windows XP Professional (Pentium). I send the message from enterprise to express the message (at once I shall tell, that sending of the message in the opposite direction gives the same ...

Back in July I released the (then) latest version of SsbAdmin. For you who don'r know what it is; it's a tool which allows you to graphically administer SQL Server Service Broker.I have now uploaded a new version which is compiled against the released versions of SQL Server 2005 and .NET ...

Is there any way to ensure that messages sent on different dialogs have the same conversation group id on the target queue? I was attempting to set the conversation group id on the dialog before sending but learned that this only works on the initator end. ...

Hello All: I've been experimenting with the new SQL Server Service Broker, and I think I've discovered some interesting behavior. Service Broker relies on "Queues" to store messages that need to be processed. Service Broker operates by sending a message from one Queue (the INITIATOR Quque) to ...

Hello All: I've been experimenting with the new SQL Server Service Broker, and I think I've discovered some interesting behavior. Service Broker relies on "Queues" to store messages that need to be processed. Service Broker operates by sending a message from one Queue (the INITIATOR Quque) to ...

I am try to start with SQL BROKER service, </P> When I lunch from sql Management studio the following query, this don't finish never.</P> ALTER DATATABLE dbname SET ENABLE_BROKER</P> </P> Where I am mistaking ?</P> </P>

I'm having some troubles with conversation groups. I need to send two messages on the same conversation group so I have the following in my SP.... BEGIN DIALOG CONVERSATION @providerConversationHandle FROM SERVICE [ProviderDataService] TO SERVICE 'CalculatedDataService' ON CONTRACT ...

Remus Rusanu has started his own blog titled "Service Broker Conversations." You can access it here. His first example shows how to build a pub-sub service using Service Broker in SQL Server 2005. ...

I am working for a client that would has XML data being passed into a Service Broker queue.The queue is configured to activate a stored procedure once a message is recieved.Inside that stored procedure I would like to you xQuery methods to find data in the xml that got passed in, however, I ...

Is there anyway to figure out which tables/objects this view uses?In SQL Server 2000 one could see the actual script of the view but in Yukon this is only possible for user-created views, right?What I am aiming for is to combine the speed of sp_spaceused with the information in ...

When I configure SSB in two machine to send message, I get a error message in target machine SQLProfiler: "Connection handshake failed. There is already an existing connection with the same peer and this connection lost the arbitration. State 80." Then I get another message "This message could ...

Hifew weeks ago I found an example of conversation using service broker.I used the following code: USE Test GO -- First, we need to create a message type. Note that our message type is -- very simple and allowed any type of content CREATE MESSAGE TYPE HelloMessage VALIDATION = NONE GO -- Once ...