Generated using SQL Data Dictionary demo version.


Table dbo.ErrorLog (0 rows)


Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.


  Column Data Type Identity Nullable Default
PK ErrorLogID int X
Primary key for ErrorLog records.
ErrorTime datetime getdate()
The date and time at which the error occurred.
UserName sysname(nvarchar(128))
The user who executed the batch in which the error occurred.
ErrorNumber int
The error number of the error that occurred.
ErrorSeverity int X
The severity of the error that occurred.
ErrorState int X
The state number of the error that occurred.
ErrorProcedure nvarchar(126) X
The name of the stored procedure or trigger where the error occurred.
ErrorLine int X
The line number at which the error occurred.
ErrorMessage nvarchar(4000)
The message text of the error that occurred.

Indexes:


Used by: