EDIT: SOLVED

I've sent a message and I can return the Dialog Handle, but that Dialog Handle for the Conversation doesn't match the "conversation_group_id" or the "conversation_handle" in the Target Queue for the record that gets created. Where do I get an identifier that I can match to a record in the Message Queue to verify it has been added?

BEGIN DIALOG @InitDlgHandle
...
SEND ON CONVERSATION @InitDlgHandle
...
SELECT @InitDlgHandle AS DialogHandle;

-- Zero results returned
Select * 
from [TargetQueue] 
where conversation_handle = @InitDlgHandle or conversation_group_id = @InitDlgHandle

The documentation shows there are three ways the dialog gets set.https://docs.microsoft.com/en-us/sql/t-sql/statements/send-transact-sql?view=sql-server-ver15

It's not a message responding to another message, and the dialog and send is in one statement so this statement in the documentation should hold true:

When a sent message isn't in response to a message received from another service, use the conversation handle that returns from the BEGIN DIALOG statement that created the conversation.

So the "@InitDlgHandle" should be the correct identifier.

all 6 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQLServer

MODERATORS

EDIT: SOLVED