>>I have just submitted to the files section my SP Builder utility. SP Builder is a straightforward, easy to use wizard that can generate several different types of stored procedures for your SQL Server database, including:
>
>Eric,
>
>I can't wait to look at it! Does it handle error trapping?

Actually, I handle errors in my Data Access class, so there is no need for me to do it directly in the SP. I am open to the suggestion though, for those who wish to do it differently- do you have examples of how you handle errors in your SPs?