SQL server standards - Error handling. (pdf, 24 pages) SQL server standards - Error handling. (htm, 24 pages) SQL server standards - Error handling - Entity relationship diagram (ERD). SQL server standards - Error handling - All the code examples (zip).   1 Table of contents 2 Overview 2.1 Subject 2.2 Summary 2.3 Audience 2.4 Limitations 2.5 Acronyms 2.6 Glossary 3 Introduction 4 Why use SQL error trapping? 5 Requirements for SQL error trapping 6 Types of errors 6.1 Execution time errors 6.2 Business logic errors 6.3 Domain / attribute integrity 7 SQL generated errors 7.1 SQL error codes 7.2 Return codes 8 User generated error codes 8.1 SQL error codes 8.2 Return codes 8.3 OUTPUT parameter 8.4 Error Resultset 9 Using Return() 9.1 SQL defined return codes 9.2 defined return codes 10 Using OUTPUT 11 Using transactions & rollback 12 Error handling with TXN code 13 Logging the errors 13.1 In the App 13.2 In SQL 14 Logging errors to a table 14.1 usp_DBA_Template_LogErrors 14.2 usp_DBA_LogError 14.3 Objects created locally in each DB 15 Generating test errors 15.1 FK error 15.2 Identity insert error 16 Code that receives the error info. 16.1 Javascript - ASP 16.2 Vbscript – ASP 16.3 TSQL 16.4 C++ 17 Retrieving the error info 18 References                                       Page search phrases: Microsoft SQL server error handling, Microsoft SQL server error trapping, Microsoft SQL server errors, Microsoft SQL server error, Microsoft SQL server error handler, Microsoft SQL server errors, Microsoft SQL server error trap.