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


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ErrorLogID  int          Primary key for ErrorLog records. 
    ErrorTime  datetime    (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          The error number of the error that occurred. 
    ErrorSeverity  int          The severity of the error that occurred. 
    ErrorState  int          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          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


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 
  uspUpdateEmployeeHireInfo  HumanResources  Procedure 
  uspUpdateEmployeeLogin  HumanResources  Procedure 
  uspUpdateEmployeePersonalInfo  HumanResources  Procedure 
  dVendor  Purchasing  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
  iPurchaseOrderDetail  Purchasing  Trigger 
  iStore  Sales  Trigger 
  iWorkOrder  Production  Trigger 
  uPurchaseOrderDetail  Purchasing  Trigger 
  uPurchaseOrderHeader  Purchasing  Trigger 
  uSalesOrderHeader  Sales  Trigger 
  uWorkOrder  Production  Trigger 
Total: 13 object(s)


    [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 ,
    )  ON [PRIMARY]

See Also

List of tables