Difference between revisions of "Dbo.ErrorLog (table)"

From dbscript Online Help
Jump to: navigation, search
Line 89: Line 89:
 
| dbo.ErrorLog
 
| dbo.ErrorLog
 
|- valign="top"
 
|- valign="top"
 
 
| '''Description
 
| '''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.
 
| 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.
 
|-
 
|-
 
 
|}
 
|}
  

Revision as of 06:58, 30 November 2009

wikibot

Table dbo.ErrorLog


Column Data Type Nullable Default PK Index
ErrorLogID int not null PK_ErrorLog_ErrorLogID
ErrorTime datetime not null (getdate())
UserName sysname not null
ErrorNumber int not null
ErrorSeverity int null
ErrorState int null
ErrorProcedure nvarchar(126) null
ErrorLine int null
ErrorMessage nvarchar(4000) not null

automatically generated

Table 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.


Column Data Type Nullable Default Description / PK / Index
ErrorLogID int not null Primary key for ErrorLog records.
PK_ErrorLog_ErrorLogID
ErrorTime datetime not null (GETDATE()) The date and time at which the error occurred.
UserName sysname 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.


Reference Type Object Type Referencing Object
Insert Procedure dbo.uspLogError