Editing Dbo.ErrorLog (table)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table
| dbo.ErrorLog
|- valign="top"
| '''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 ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description

|- valign="top"
| ErrorLogID
| int
| not null
| 
| Primary key for ErrorLog records.
|- valign="top"
| ErrorTime
| datetime
| not null
| (getdate())
| The date and time at which the error occurred.
|- valign="top"
| UserName
| sysname
| not null
| 
| The user who executed the batch in which the error occurred.
|- valign="top"
| ErrorNumber
| int
| not null
| 
| The error number of the error that occurred.
|- valign="top"
| ErrorSeverity
| int
| null
| 
| The severity of the error that occurred.
|- valign="top"
| ErrorState
| int
| null
| 
| The state number of the error that occurred.
|- valign="top"
| ErrorProcedure
| nvarchar(126)
| null
| 
| The name of the stored procedure or trigger where the error occurred.
|- valign="top"
| ErrorLine
| int
| null
| 
| The line number at which the error occurred.
|- valign="top"
| ErrorMessage
| nvarchar(4000)
| not null
| 
| The message text of the error that occurred.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key
| '''Columns
|- valign="top"
| PK_ErrorLog_ErrorLogID
| ErrorLogID
|}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

|- valign="top"
| Insert
| Procedure
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]

|}


== automatically generated ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| dbo.ErrorLog
|- valign="top"

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

|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| ErrorLogID
| int
| not null
| 
| Primary key for ErrorLog records.<br />PK_ErrorLog_ErrorLogID
|- valign="top"
| ErrorTime
| datetime
| not null
| (GETDATE())
| The date and time at which the error occurred.<br />
|- valign="top"
| UserName
| sysname
| not null
| 
| The user who executed the batch in which the error occurred.<br />
|- valign="top"
| ErrorNumber
| int
| not null
| 
| The error number of the error that occurred.<br />
|- valign="top"
| ErrorSeverity
| int
| null
| 
| The severity of the error that occurred.<br />
|- valign="top"
| ErrorState
| int
| null
| 
| The state number of the error that occurred.<br />
|- valign="top"
| ErrorProcedure
| nvarchar(126)
| null
| 
| The name of the stored procedure or trigger where the error occurred.<br />
|- valign="top"
| ErrorLine
| int
| null
| 
| The line number at which the error occurred.<br />
|- valign="top"
| ErrorMessage
| nvarchar(4000)
| not null
| 
| The message text of the error that occurred.<br />
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

|-
| Insert
| Procedure
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]

|}