dbo.ErrorLog Table

Information

Name	ErrorLog
Schema	dbo
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:18

Extended Properties

Name	Type	Property Name	Value
ErrorLog	TABLE	MS_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	Collation	Default
ErrorLogID	int
ErrorTime	datetime		(getdate())
UserName	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS
ErrorNumber	int
ErrorSeverity	int
ErrorState	int
ErrorProcedure	nvarchar(126)	SQL_Latin1_General_CP1_CI_AS
ErrorLine	int
ErrorMessage	nvarchar(4000)	SQL_Latin1_General_CP1_CI_AS

Indexes

Name	Type	Primary	Unique	Columns
PK_ErrorLog_ErrorLogID	Clustered			ErrorLogID

SQL Script

CREATE TABLE [dbo].[ErrorLog] (
    [ErrorLogID] int NOT NULL IDENTITY,
    [ErrorTime] datetime NOT NULL DEFAULT (getdate()),
    [UserName] nvarchar(128) NOT NULL,
    [ErrorNumber] int NOT NULL,
    [ErrorSeverity] int NULL,
    [ErrorState] int NULL,
    [ErrorProcedure] nvarchar(126) NULL,
    [ErrorLine] int NULL,
    [ErrorMessage] nvarchar(4000) NOT NULL
);