Dbo.ErrorLog (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Dependencies 2 automatically generated

wikibot

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

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

Primary Key	Columns
PK_ErrorLog_ErrorLogID	ErrorLogID

Dependencies

Reference Type	Object Type	Referencing Object
Insert	Procedure	dbo.uspLogError

automatically generated

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