AdventureWorks

Basic Index   Expanded Index

Table Name:dbo.ErrorLog
Description: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.
Primary Keys:ErrorLogID
FieldTypeDefaultsNulls?Comments
ErrorLogIDint - IdentityNoneNoPrimary key for ErrorLog records.
ErrorTimedatetime(getdate())NoThe date and time at which the error occurred.
UserNamenvarchar (128)NoneNoThe user who executed the batch in which the error occurred.
ErrorNumberintNoneNoThe error number of the error that occurred.
ErrorSeverityintNoneYesThe severity of the error that occurred.
ErrorStateintNoneYesThe state number of the error that occurred.
ErrorProcedurenvarchar (126)NoneYesThe name of the stored procedure or trigger where the error occurred.
ErrorLineintNoneYesThe line number at which the error occurred.
ErrorMessagenvarchar (4000)NoneNoThe message text of the error that occurred.

IndexClustered?Unique?Fields
PK_ErrorLog_ErrorLogIDYesYesErrorLogID

No check constraints
No internal foreign key constraints
No primary keys as foreign key constraints
No triggers