Alter Service &&<SVC1&&> (Add Contract &&<CONTRACT&&>) Does Not Really Work, Need Help

Hi,

Sure you can run


Create Service SVC1 ON QUEUE QUEUE1 (CONTRACT1);

alter service SVC1 (add contract CONTRACT2);

But You can only send message using contract1, when you try to send msg using contract2, it always say can not find CONTRACT "contract2".

The following query shows the contract is there.

select s.*,c.* from sys.service_contract_usages U

inner join sys.services S on S.service_id = U.service_id

inner join sys.service_contracts C on U.service_contract_id=C.service_contract_id

where S.name='SVC1'



declare @lMsg xml

declare @ConversationHandle uniqueidentifier

set @lMsg = '<test>testing</test>'

Begin Transaction

Begin Dialog @ConversationHandle

From Service SVC1

To Service 'SVC2'

On Contract contract1

WITH Encryption=off;

SEND

ON CONVERSATION @ConversationHandle

Message Type [type1]

Commit

The above works, but the following will not work.


declare @lMsg xml

declare @ConversationHandle uniqueidentifier

set @lMsg = '<test>testing</test>'

Begin Transaction

Begin Dialog @ConversationHandle

From Service SVC1

To Service 'SVC2'

On Contract CONTRACT2

WITH Encryption=off;

SEND

ON CONVERSATION @ConversationHandle

Message Type [type2]

(@lMsg)

Commit

Any idea ?

Thanks!