I have an update to this issue for those that can benefit from it.

As I stated in my original post, the SQL procedure is indeed executing correctly. All RAISERROR throws...

OK, taken on board.

RBarryYoung,

Are you generally happy with my T-SQL syntax and usage?

Do you have any observation to make about that?

Stu:)

Thanks RBarryYoung,

The client app is mine. I'm the author. It's an in house app so therefore will not be known to you.

I will check out some ADODB issues and see...