ErrorLog Table (AdventureWorks)
Records all errors in the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by the dbo.uspLogError stored procedure when that procedure is executed from inside the CATCH block of a TRY...CATCH construct.
ErrorLog Table Definition
The ErrorLog table is contained in the dbo schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
ErrorLogID |
int |
Not null |
Primary key for ErrorLog rows. |
ErrorTime |
datetime |
Not null |
Date and time the error occurred. |
UserName |
sysname |
Not null |
User that executed the batch in which the error occurred. |
ErrorNumber |
int |
Not null |
Error number of the error that occurred. |
ErrorSeverity |
int |
NULL |
Severity of the error that occurred. |
ErrorState |
int |
NULL |
State number of the error that occurred. |
ErrorProcedure |
nvarchar(126) |
NULL |
Name of the stored procedure or trigger where the error occurred. |
ErrorLine |
int |
NULL |
Line number at which the error occurred. |
ErrorMessage |
nvarchar(4000) |
Not null |
Message text of the error that occurred. |
See Also
Concepts
Stored Procedures in AdventureWorks
Other Resources
AdventureWorks Data Dictionary
TRY...CATCH (Transact-SQL)
Using TRY...CATCH in Transact-SQL