title: Asp.net -best place to trap SQL Server sql errors
body: <p>For Asp.net web applications, is it best to:</p>
  
  <ol>
  <li>trap errors within sql stored procedures and test for a return value in the code or </li>
  <li>just let the error occur in sql (dont handle it) and rely on ado.net raising the errors within the code.</li>
  </ol>
  
  <p>What are the best practises here?</p>