Dbo.ErrorLog (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table 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.

Columns[edit]

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

Primary Key[edit]

Primary Key Columns
PK_ErrorLog_ErrorLogID ErrorLogID

Dependencies[edit]

Reference Type Object Type Referencing Object
Insert Procedure dbo.uspLogError


automatically generated[edit]

Table 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.


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


Reference Type Object Type Referencing Object
Insert Procedure dbo.uspLogError