dbo ErrorLog (table)

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized
== 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
| &nbsp;
| 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
| &nbsp;
| The user who executed the batch in which the error occurred.
|- valign="top"
| ErrorNumber
| int
| not null
| &nbsp;
| The error number of the error that occurred.
|- valign="top"
| ErrorSeverity
| int
| null
| &nbsp;
| The severity of the error that occurred.
|- valign="top"
| ErrorState
| int
| null
| &nbsp;
| The state number of the error that occurred.
|- valign="top"
| ErrorProcedure
| nvarchar(126)
| null
| &nbsp;
| The name of the stored procedure or trigger where the error occurred.
|- valign="top"
| ErrorLine
| int
| null
| &nbsp;
| The line number at which the error occurred.
|- valign="top"
| ErrorMessage
| nvarchar(4000)
| not null
| &nbsp;
| 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]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

dbo ErrorLog (table)
