Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: dbo ErrorLog (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:04


wikibot

Tabledbo.ErrorLog
DescriptionAudit 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

ColumnData TypeNullableDefaultDescription
ErrorLogIDintnot null Primary key for ErrorLog records.
ErrorTimedatetimenot null(getdate())The date and time at which the error occurred.
UserNamesysnamenot null The user who executed the batch in which the error occurred.
ErrorNumberintnot null The error number of the error that occurred.
ErrorSeverityintnull The severity of the error that occurred.
ErrorStateintnull The state number of the error that occurred.
ErrorProcedurenvarchar(126)null The name of the stored procedure or trigger where the error occurred.
ErrorLineintnull The line number at which the error occurred.
ErrorMessagenvarchar(4000)not null The message text of the error that occurred.

Primary Key

Primary KeyColumns
PK_ErrorLog_ErrorLogIDErrorLogID

Dependencies

Reference TypeObject TypeReferencing Object
InsertProceduredbo.uspLogError

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.