Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | dbo.ErrorLog | | | 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" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- style="background:silver" | | |- style="background:silver" |
Line 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | ErrorLogID | | | ErrorLogID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key for ErrorLog records. | + | | PK_ErrorLog_ErrorLogID |
− | |- valign="top" | + | | |
| + | |- |
| | ErrorTime | | | ErrorTime |
| | datetime | | | datetime |
| | not null | | | not null |
| | (getdate()) | | | (getdate()) |
− | | The date and time at which the error occurred. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | UserName | | | UserName |
| | sysname | | | sysname |
| | not null | | | not null |
| | | | | |
− | | The user who executed the batch in which the error occurred. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ErrorNumber | | | ErrorNumber |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | The error number of the error that occurred. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ErrorSeverity | | | ErrorSeverity |
| | int | | | int |
| | null | | | null |
| | | | | |
− | | The severity of the error that occurred. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ErrorState | | | ErrorState |
| | int | | | int |
| | null | | | null |
| | | | | |
− | | The state number of the error that occurred. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ErrorProcedure | | | ErrorProcedure |
| | nvarchar(126) | | | nvarchar(126) |
| | null | | | 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 | + | | ErrorLine |
− | | 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 | | | int |
| | null | | | 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 | | | ErrorMessage |
| | nvarchar(4000) | | | nvarchar(4000) |
| | not null | | | 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]]
| |
− | | |
| |} | | |} |