I have a service broker service and there are multiple clients that can put messages in the queue of that service. How do I check which message comes from which client There is no field in the queue like message_senderId or something like that.
How do I know where my message come from
Hot Topic
- sp_send_dbmail won't work using @query get information from temporary table
- Missing dimension members in many-to-many
- Remote SSIS connection problem
- SQL Server 2000 & Reporting Services (Report Manager)
- Query behaviour
- Read/Write Performance
- Package running other packages
- Mining Access 2003
- Can't Create New Database on Device via ActiveSync
- Script databsae does not compatible with SQL2000
SQL Server
- SQL Server Management Studio Express CTP won't open - why?
- SQL Server Reporting Services
- snapshot replication problem
- Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable
- backup does not backup
- INT32 vs INT64 vs GUID vs NEWSEQUENTIALID
- UK Datetime parameter problem SQL 2005 RS
- Unable to connect to Analysis Services as a client
- "Network general error"....
- Using Partitioned Views in SQL Server 2005 Standard Edition
How do I know where my message come from
Jeremy Boyd
If all you need is to send back replies, then is not necesary too know the sender of the message. Simply send back replies on the conversation_handle received and they'll reach the sender.
If you need to know for other reasons, look up sys.conversation_endpoints by the conversation_handle of the received message. It contains the far_fervice and far_broker_instance fields, that are the name of the service that sent the message and the service_broker_guid of the database that hosts that service.
HTH,
~ Remus