"Ty" <tybala on the server at hotmail.com> wrote in message
news:e#Cu5k1PDHA.304@tk2msftngp13.phx.gbl...
> Hi all,
>
> I am shredding really large XML files into SQL via SP_XML_PrepareDoc. I
do
> a lot of internal error handling within the SPROC, and I always call
> SP_XML_RemoveDocument before I call RAISERROR.
>
> While this is great for ensuring I do not use up precious RAM for
> RAISERRORS, how would I go about ensuring that SP_XML_RemoveDocument gets
> called when a constraint raises the error?
>
> Thanks in advance,
> /Ty
>
>
>