Integrating to the max...BizTalk Style

In our project we are doing some additional logging like message payload, customer ids etc. The other day i want to provide the request/response times based on the starting point of the business transaction and information in an XML column that was filled when the message was sent. On a lot of websites i could find some examples but they all involved using namespaces etc. I thought i could do that with the lazy-goggles on and hereby the starting point of what is now a monster query ;) SELECT m.id as MessageID, i.createdon MessageReceived, CAST( m.messagesent.query('//*[local-name() = ''Timestamp'']/text()') as varchar) MessageSent FROM instance i, message m WHERE m.parentid = i.id and i.customerref = 'CUSTID_00014041' and CAST (m.messagesent.query('//*[local-name() = ''Action'']/text()') as varchar) = 'SendResponse' Note: the is required for the <xmlcolumn...

Recently i had the ability to use 2 dedicated development machines, one for setting up BizTalk and i figured to use the other for SQL Server. I sounds easy enough, be it that there are some steps that you should not forget. Possible error to look for: “Cannot open database BizTalkMgmtDb on server <dummy>.Verify that you have the required security permissions and that communication between Distributed Transaction Coordinator services on the machines involved is not prevented by current DTC security,   firewall or authentication settings.” Setting up the machines Preconditions: o SQL Server is installed o BizTalk is installed but not configured Setting up the SQL Server machine 1) Start ‘SQL Server Surface Area Configuration’ o Enable remote connections (Choose: TCP/IP or TCP/IP and named pipes, disable shared memory) o Start the SQL Agent o Start the SQL Browser 2) Start ‘SQL Server Configuration Management’ o Goto ‘Protocols for MSSQL Server...