From dbscript Online Help
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
|