simple stored procedure concept questions

[rtgordon]

I have read some elementary stored procedure tutorials, and I am looking at using stored procedures with ASP, and I still have a few fundamental questions regarding stored procedures.

regarding committing and rolling back, if one of the queries fails between a BEGIN and an END, does the entire stored procedure fail? I am assuming it does, but have not found anything supporting this.

Also, how do I do client validation (ASP) to determine whether the stored procedure failed or succeeded?

Thanks,
gordon