• Hi

    Before start doing this, first you need to find out what kind of errors you are expecting!!! then code it accordngly.

    Check out the below link

    http://www.sql-server-performance.com/articles/dev/exception_handling_p1.aspx