Hi All,
I am trying to process some data submitted
via a web service.
I would like some guidance as to the best
approach to retrieive error information
and allowing for rollbacks.

Normally I would do the validation in code C# but as I want to allow for rollbacks I was hoping to do much of the validation in the stored proceedure to take advantage of transactions.

I haven't used T-SQL to this degree before and want to know how I can trap errors in SQL, allow the process to continue to the next record, and finally throw an exception, if errors occured, that I can trap in C#.

Can anyone recommend a good artricle or tutorial on this kind of subject.

Many Thanks. Rod

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

__________________
======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================