How to handle errors??

[8Ne0]

I am developing a web application with an SQL Server database. A good bit of the sites functionality is going to be written in transact sql in stored procedures.<BR><BR>My question is this: Should something go wrong, what is the best way to handle errors? I had thought to use return values to indicate success or not, but I dont' think that will work.<BR><BR>Is there a better way?Use a Try Catch block.<BR>When using transactions you can do a rollback when errors are incountered. Then maybe give some error message.<BR><BR>Aaron