AdventureWorks - dbo.ErrorLog

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

Field	Type	Defaults	Nulls?	Comments
ErrorLogID	int - Identity	None	No	Primary key for ErrorLog records.
ErrorTime	datetime	(getdate())	No	The date and time at which the error occurred.
UserName	nvarchar (128)	None	No	The user who executed the batch in which the error occurred.
ErrorNumber	int	None	No	The error number of the error that occurred.
ErrorSeverity	int	None	Yes	The severity of the error that occurred.
ErrorState	int	None	Yes	The state number of the error that occurred.
ErrorProcedure	nvarchar (126)	None	Yes	The name of the stored procedure or trigger where the error occurred.
ErrorLine	int	None	Yes	The line number at which the error occurred.
ErrorMessage	nvarchar (4000)	None	No	The message text of the error that occurred.

Index	Clustered?	Unique?	Fields
PK_ErrorLog_ErrorLogID	Yes	Yes	ErrorLogID

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