Dbo.ErrorLog (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:17Z

Bot at 21:59, 23 June 2010

2010-06-23T21:59:28Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:27Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:36Z

Bot at 05:58, 30 November 2009

2009-11-30T05:58:51Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:13Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:04Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:31Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:29Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:16Z

@@ Line 95: / Line 95: @@
 | Insert
 | Procedure
-| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
+| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | dbo.ErrorLog
@@ Line 8: / Line 8: @@
 | '''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 ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ErrorLogID
@@ Line 82: / Line 80: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ErrorLog_ErrorLogID
 | ErrorLogID
@@ Line 94: / Line 92: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Insert
 | Procedure
-| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
+| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for ErrorLog records.<br />PK_ErrorLog_ErrorLogID
+| Primary key for ErrorLog records.
 |- valign="top"
 | ErrorTime
@@ Line 31: / Line 32: @@
 | not null
 | (getdate())
-| The date and time at which the error occurred.<br />
+| The date and time at which the error occurred.
 |- valign="top"
 | UserName
@@ Line 37: / Line 38: @@
 | not null
+|
-| The user who executed the batch in which the error occurred.<br />
+| The user who executed the batch in which the error occurred.
 |- valign="top"
 | ErrorNumber
@@ Line 43: / Line 44: @@
 | not null
+|
-| The error number of the error that occurred.<br />
+| The error number of the error that occurred.
 |- valign="top"
 | ErrorSeverity
@@ Line 49: / Line 50: @@
 | null
+|
-| The severity of the error that occurred.<br />
+| The severity of the error that occurred.
 |- valign="top"
 | ErrorState
@@ Line 55: / Line 56: @@
 | null
+|
-| The state number of the error that occurred.<br />
+| The state number of the error that occurred.
 |- valign="top"
 | ErrorProcedure
@@ Line 61: / Line 62: @@
 | null
+|
-| The name of the stored procedure or trigger where the error occurred.<br />
+| The name of the stored procedure or trigger where the error occurred.
 |- valign="top"
 | ErrorLine
@@ Line 67: / Line 68: @@
 | null
+|
-| The line number at which the error occurred.<br />
+| The line number at which the error occurred.
 |- valign="top"
 | ErrorMessage
@@ Line 73: / Line 74: @@
 | not null
+|
-| The message text of the error that occurred.<br />
+| The message text of the error that occurred.
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 90: / Line 100: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | dbo.ErrorLog
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ErrorLogID
 | int
 | not null
+|
-| PK_ErrorLog_ErrorLogID
+| 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 />
+|}
 |}
 == automatically generated ==

@@ Line 89: / Line 89: @@
 | 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.
 |-
 |}

@@ Line 168: / Line 168: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]