Database error contains an error number, message string, severity, state, and procedure name and line number. Error can be handled in the database by adding error-handling code to translate-sql, batches, procedure, trigger or function. Each application use to access database, provide mechanisms for passing the error to application.
| Error Number | Each error message has a unique error number. |
| Error message string | The error message contains diagnostic information about the cause of the error. |
| Severity | The severity indicates how serious the error is. |
| State | Some error messages can be raised at multiple points in the code for the Database, This information might provide additional ideas on how to diagnose the problem. |
| Procedure name | Is the name of the stored procedure or trigger in which the error has occurred. |
| Line number | Indicates which statement in a batch, stored procedure, trigger, or function generated the error. |