In the sp I call if the insert/updates fail for the order header or detail I return 1 and want to rollback that particular order. How could I avoid using...

Jonathon,

Thanks for the help I moved the 'SET NOCOUNT ON' After the Begin instead of directly after the AS and it appears to work fine now.

Thanks,

Bayani

I have already Set NoCount to ON but it still returns the same error. I also tried using a temp table but it also returns the same error.

Thanks,

Bayani