Geeks With Blogs
Edmund Zhao's BizTalk abc We share, We learn September 2011 Entries
Temp table in strongly typed stored procedure not supported by WCF SQL adapter
If your orchestration is heavily rely on WCF SQL adapter based on SQL stored procedures, you may often encounter an issue related to strongly-typed schema and receive an error which is similar to the following. The adapter failed to transmit message going to send port "WcfSendPort" with URL "mssql://sqlserver//databas... It will be retransmitted after the retry interval specified for this Send Port. Details:"System.Data.SqlCli... Invalid object name '#Temp'. This is because of the ......

Posted On Sunday, September 4, 2011 6:36 PM

Copyright © Edmund Zhao | Powered by: