You can use the RFSQL Com call to execute a stored proc
from an orchestration and return back a value indicating
pass or fail.

Mike
>-----Original Message-----
>I have installed the "Microsoft BizTalk Adapter for SQL
>Server" and got the Samples to work fine...but I need to
>know when the insert, update or delete fails, via a
stored
>procedure. I was hoping to use the "Microsoft BizTalk
>Adapter for SQL Server" in an xlang but have not had
much
>luck so far. Has anyone out there called a stored proc
>from biztalk and have gotten a response back to indicate
>it worked or not? Regards -Ben
>.
>

[ Post a follow-up to this message ]

Mike, I'd like to try that, can you tell me how to invoke the RFSQL Com call
?
Ben

"Michael Krok" <mkrok@hotmail.com> wrote in message news:<122a201c3f623$0a0da320$a001280
a@phx.gbl>...
> You can use the RFSQL Com call to execute a stored proc
> from an orchestration and return back a value indicating
> pass or fail.
>
> Mike 
>  stored 
>  much 

[ Post a follow-up to this message ]

working with Ben offline.  If anyone would like this
solution please send me an email.

Michael
>-----Original Message-----
>Mike, I'd like to try that, can you tell me how to
invoke the RFSQL Com call?
>Ben
>
>"Michael Krok" <mkrok@hotmail.com> wrote in message
news:<122a201c3f623$0a0da320$a001280a@phx.gbl>... 
proc 
indicating 
SQL 
to 
proc 
indicate 
>.
>

[ Post a follow-up to this message ]