Databases > AdventureWorks2019 > Tables > ErrorLog

AdventureWorks2019

ErrorLog

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.

Created: 5/8/2023 Modified: 5/8/2023

Columns

//

${escapify(column.description)}

ErrorLogID

[int] IDENTITY (1,1) NOT NULL
//

${escapify(column.description)}

ErrorTime

[datetime] NOT NULL DEFAULT (getdate())
//

${escapify(column.description)}

UserName

[sysname] NOT NULL
//

${escapify(column.description)}

ErrorNumber

[int] NOT NULL
//

${escapify(column.description)}

ErrorSeverity

[int] NULL
//

${escapify(column.description)}

ErrorState

[int] NULL
//

${escapify(column.description)}

ErrorProcedure

[nvarchar](126) NULL
//

${escapify(column.description)}

ErrorLine

[int] NULL
//

${escapify(column.description)}

ErrorMessage

[nvarchar](4000) NOT NULL

Indexes

//

Clustered index created by a primary key constraint.

PK_ErrorLog_ErrorLogID

UNIQUE CLUSTERED

ErrorLogID

Sample Data

No Sample Data