Difference between revisions of "Dbo.ErrorLog (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | dbo.ErrorLog |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...)
 
 
(13 intermediate revisions by the same user not shown)
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 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ErrorLogID
 
| ErrorLogID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ErrorLog_ErrorLogID
+
| Primary key for ErrorLog records.
−
|
+
|- 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
 +
| 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.
 
|-
 
|-
−
| ErrorNumber
+
|}
 +
 
 +
 
 +
{| 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
 
| int
 
| not null
 
| 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
 
| ErrorSeverity
 
| int
 
| int
 
| null
 
| null
 
|  
 
|  
−
|  
+
| The severity of the error that occurred.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ErrorState
 
| ErrorState
 
| int
 
| int
 
| null
 
| null
 
|  
 
|  
−
|  
+
| The state number of the error that occurred.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ErrorProcedure
 
| ErrorProcedure
 
| nvarchar(126)
 
| nvarchar(126)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| The name of the stored procedure or trigger where the error occurred.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ErrorLine
 
| ErrorLine
 
| int
 
| int
 
| null
 
| 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]]
 +
 
 
|}
 
|}

Latest revision as of 00:15, 24 June 2010

wikibot[edit]

Table dbo.ErrorLog
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[edit]

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

Primary Key[edit]

Primary Key Columns
PK_ErrorLog_ErrorLogID ErrorLogID

Dependencies[edit]

Reference Type Object Type Referencing Object
Insert Procedure dbo.uspLogError


automatically generated[edit]

Table dbo.ErrorLog
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.


Column Data Type Nullable Default Description / PK / Index
ErrorLogID int not null Primary key for ErrorLog records.
PK_ErrorLog_ErrorLogID
ErrorTime datetime not null (GETDATE()) The date and time at which the error occurred.
UserName sysname not null The user who executed the batch in which the error occurred.
ErrorNumber int not null The error number of the error that occurred.
ErrorSeverity int null The severity of the error that occurred.
ErrorState int null The state number of the error that occurred.
ErrorProcedure nvarchar(126) null The name of the stored procedure or trigger where the error occurred.
ErrorLine int null The line number at which the error occurred.
ErrorMessage nvarchar(4000) not null The message text of the error that occurred.


Reference Type Object Type Referencing Object
Insert Procedure dbo.uspLogError
Retrieved from "http://dbshelp.devio.at/index.php?title=Dbo.ErrorLog_(table)&oldid=2576"