dbo.ErrorLog

Table: 'dbo.ErrorLog'

9 fields. 8544 bytes.

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.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ErrorLogID	int identity		int		Not null	Primary key for ErrorLog records.
ErrorTime	datetime			getdate()	Not null	The date and time at which the error occurred.
UserName	sysname	128	nvarchar(128)		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.

Extended Properties

The object has no extended properties.

Primary key for table 'dbo.ErrorLog'

Primary Key Name	Field Name
PK_ErrorLog_ErrorLogID	ErrorLogID

There are no Foreign Keys for this table.

Indexes for table 'dbo.ErrorLog', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_ErrorLog_ErrorLogID	Clustered index created by a primary key constraint.	Yes	Yes	ErrorLogID

There are no Triggers for this table.

Dependencies for table 'dbo.ErrorLog', 1 item

Object Name	Type	Field Name
dbo.uspLogError	stored procedure	N/A