I'm trying to call a stored procedure on the local server that also stores my Biztalk installation. The SP is in a logging database I have and I'm logging my incoming messages to include the source application name, the message type and the actual XML string of the message.
I can call the SP just fine from Query Analyzer, but after I create the schemas from the adapter and try to call the adapter via a send port in an orchestration, I receive an error from the port stating that it could not locate a table that used to exist in the database. Now, the SP that is being called has NO link to the table or object that is being reported on as an error.
Anybody seen this before?
TIA
-Rich