[BizTalk] SQL Adapter 0x8000405 error

When querying database via SQL adapter, I got a 0x8000405 error on event log

SQL Adapter send/receive Xml data, when creating SQL request/response xml schema, we need to add "for xml auto,xmldata" in your stored procedule so the wizard can have xml schema returned from stored procedule.

After schema is generated, you will need to remove "xmldata" from your stored procedule, or 0x800405 error will be logged, and your query failed with the following error description "Streaming not supported over multiple column result".

[.Net][Remoting] Remoting with TCP channel and NLB

.Net framework 1.1 has some problem with TCP channel in NLB.
In .Net framework 2.0, TCP channel has been enhenced to support real world network environment.
The following configuration settings are useful when configuring TCP Remoting with NLB

<channels>
   <channel port="xxx" ref="tcp" socketcachetimeout="0" socketcachepolicy="absoluteTimeout" />
</channels>

Here is what you need to know about Microsoft supports for .Net Remoting with NLB.