Thank you. Fascinating solution; it works perfectly

Using the system tables was my fall back; I was just of the impression that there would be a better method of determining column attributes.

As to why I took this...

Thank you for the response. It seemed that I needed to use the alter authorization command to alleviate this issue.

A follow-on question. In the activation procedure if there are no...

Thank-you for all of the help. I believe that I have figured out the problem. I was using different contract names in the sender and reciever databases. I made those...

Thank you for the advice. What I have done is similar adding an else statement and adding a xp_logevent call to not that the queue identifier is undefined. What is...

I realized that I had not created the master key on the recieving database. I went back and started over dropping both databases and recreating everything this time including the...

I dropped the contract and changed initiator to INITIATOR and added a END CONVERSATION after the send and now there are no errors on the sender side. But, there is...

Sorry about that.

The error code is: -8425

The error text is:

The service contract 'RecordSalesContract' is not found.

if I use the query

Select *,cast(message_body as xml) from RecordSalesQueue

The error message is:

This makes no sense since a select from sys.service_contracts shows that the RecordSalesContract service contract...

Maybe I am just missing something though I think I have configured correctly. I have attached 2 files the "sendSample" piece is the database that starts the conversation, the "receiverSample"...

Your presentation and example code are helpful but my code is still not working. On the database where the dialog is started, the stored procedure containing the logic to start...

Think I understand the mechanics of a trusted login. The application can validate the user credentials against the AD and get the group. The group is used for the login...

I appreciate the feedback it is very helpful. But I need a bit of clarification. You stated that you add the groups as logins. Does this infer that when a...

Thank you for the response. I changed the role creation so that role that has execute permission on the procedure could impersonate sa. I then added an "execute as login...

Thank you for the help.