ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
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''' |- | ErrorLogID | int | not null | | Primary key for ErrorLog records.<br />PK_ErrorLog_ErrorLogID |- | ErrorTime | datetime | not null | (GETDATE()) | The date and time at which the error occurred.<br /> |- | UserName | sysname | not null | | The user who executed the batch in which the error occurred.<br /> |- | ErrorNumber | int | not null | | The error number of the error that occurred.<br /> |- | ErrorSeverity | int | null | | The severity of the error that occurred.<br /> |- | ErrorState | int | null | | The state number of the error that occurred.<br /> |- | ErrorProcedure | nvarchar(126) | null | | The name of the stored procedure or trigger where the error occurred.<br /> |- | ErrorLine | int | null | | The line number at which the error occurred.<br /> |- | 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.