I have two databases
- DB1
- DB2
I have a procedure dbo.Procedure
in both of those databases.
I'm using "Consume Adapter Service" in order to execute those procedures from BizTalk.
On execution I'm getting error:
A response message sent to adapter "WCF-Custom" on Receive Location: xxx... Reason: Cannot locate document specification because multiple schemas matched the message type http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo#Procedure".
How can I solve this issue without renaming procedure in DB1 or DB2?