dbo.ErrorLog Table
Information
| Name | ErrorLog |
| Schema | dbo |
| Row Count | 0 |
| Data Size | 0 KB |
| Index Size | 0 KB |
| Reserved Size | 0 KB |
| Unused Size | 0 KB |
| Created | 14.10.2005 1:58:27 |
| Modified | 14.10.2005 1:58:27 |
Extended Properties
| Name | Type | Property Name | Value |
|---|---|---|---|
| ErrorLog | TABLE | MS_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
| PK | Key | Identity | Name | Data Type | Allow Nulls | Collation | References | Default | Computed | Compute Expression |
|---|---|---|---|---|---|---|---|---|---|---|
| ErrorLogID | int | |||||||||
| ErrorTime | datetime | (getdate()) | ||||||||
| UserName | nvarchar(256) | SQL_Latin1_General_CP1_CI_AS | ||||||||
| ErrorNumber | int | |||||||||
| ErrorSeverity | int | |||||||||
| ErrorState | int | |||||||||
| ErrorProcedure | nvarchar(252) | SQL_Latin1_General_CP1_CI_AS | ||||||||
| ErrorLine | int | |||||||||
| ErrorMessage | nvarchar(8000) | SQL_Latin1_General_CP1_CI_AS |
Indexes
| Name | Type | Primary | Unique | Columns |
|---|---|---|---|---|
| PK_ErrorLog_ErrorLogID | Clustered | ErrorLogID |