>>Bill
>
>Thanks, that's clever. I will have to put it in my bag of tricks.
>
>What we do now is use RaisError in the SP with a severity higher than 11 and then SQLExec returns a -1 and we can use aerror to get the error info.
>
>BOb

Excellent. That's good to know too and will go into my bag. :-)

Bill