Properties

Owner:	dbo
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	0
Index Size KB:	0
Rows:	0
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

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

Total: 9 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	ErrorLogID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_ErrorLog_ErrorLogID			Primary key (clustered) constraint

Total: 1 index(es)

Objects that depend on [dbo].[ErrorLog]

	Object Name	Owner	Object Type	Dep Level
	uspLogError	dbo	Procedure	1
	uspUpdateEmployeeHireInfo	HumanResources	Procedure	2
	uspUpdateEmployeeLogin	HumanResources	Procedure	2
	uspUpdateEmployeePersonalInfo	HumanResources	Procedure	2
	dVendor	Purchasing	Trigger	2
	iduSalesOrderDetail	Sales	Trigger	2
	iPurchaseOrderDetail	Purchasing	Trigger	2
	iStore	Sales	Trigger	2
	iWorkOrder	Production	Trigger	2
	uPurchaseOrderDetail	Purchasing	Trigger	2
	uPurchaseOrderHeader	Purchasing	Trigger	2
	uSalesOrderHeader	Sales	Trigger	2
	uWorkOrder	Production	Trigger	2

Total: 13 object(s)

SQL

CREATE TABLE [ErrorLog] (
    [ErrorLogID] [int] IDENTITY (1, 1) NOT NULL ,
    [ErrorTime] [datetime] NOT NULL CONSTRAINT [DF_ErrorLog_ErrorTime] DEFAULT (getdate()),
    [UserName] [sysname] NOT NULL ,
    [ErrorNumber] [int] NOT NULL ,
    [ErrorSeverity] [int] NULL ,
    [ErrorState] [int] NULL ,
    [ErrorProcedure] [nvarchar] (126) COLLATE Latin1_General_CS_AS NULL ,
    [ErrorLine] [int] NULL ,
    [ErrorMessage] [nvarchar] (4000) COLLATE Latin1_General_CS_AS NOT NULL ,
    CONSTRAINT [PK_ErrorLog_ErrorLogID] PRIMARY KEY  CLUSTERED
    (
        [ErrorLogID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables