I'm using an updatgram to delete a record from a table based on a parameter
I'm sending. . I need to know if the delete was successful or it failed. How
can I find out?The updategram contains a child called "success" . Can it be
used to check whether the deletion has been successful? If so, How?

--hasan

[ Post a follow-up to this message ]

Hasan,

In SQL profiler, you can see the exact transact sql that BizTalk is submitti
ng
to Sql Server, and any type of response that it is sending back.
I would highly recommend , calling a Stored procedure instead of a
updategram.
You will have much more control on what to do, depending on the success or
failure
of the outcome of your delete.

Matt.

"hasan" wrote:

> I'm using an updatgram to delete a record from a table based on a paramete
r
> I'm sending. . I need to know if the delete was successful or it failed. H
ow
> can I find out?The updategram contains a child called "success" . Can it b
e
> used to check whether the deletion has been successful? If so, How?
>
> --hasan
>

[ Post a follow-up to this message ]

Thanks for the reply Matt.
The reason I wanted to use an update gram is that I read somewhere that
updategrams are a lot more efficient as compared to stored procedures. If I
was to add an element of type string to success, would I be able to access
whatever was returned? (I'm basing this on the fact that the success child i
s
of type "any".)Comments would be welcome.

thanks,
--hasan

"Matt Meleski" wrote:
[vbcol=seagreen]
> Hasan,
>
> In SQL profiler, you can see the exact transact sql that BizTalk is submit
ting
> to Sql Server, and any type of response that it is sending back.
> I would highly recommend , calling a Stored procedure instead of a
> updategram.
> You will have much more control on what to do, depending on the success or
> failure
> of the outcome of your delete.
>
> Matt.
>
> "hasan" wrote:
> 

[ Post a follow-up to this message ]