Table: Error_Log
Surrogate Key, Primary Key, Clustering Key, Identity constraint. This column is maintenance for referential integrity and serves no exterial buisness constraint.
Columns
Name | Type | Constraints | Description
error_log_KEY | int (4) | NOT NULL | Surrogate Key, Primary Key, Clustering Key, Identity constraint. This column is maintenance for referential integrity and serves no exterial buisness constraint.
time_stamp | datetime (8, 3) | NOT NULL | The datetime point when the error occurred.
error_user | sysname (256) | NOT NULL | The database user name running the process where the error occurred. http://msdn.microsoft.com/en-us/library/ms188014(v=sql.105).aspx
error_login | sysname (256) | NOT NULL | The server login running the process where the error occurred. http://msdn.microsoft.com/en-us/library/ms187934(v=sql.105).aspx
error_original_login | sysname (256) | NOT NULL | The original login running the process where the error occured. This will differ from [error_login] when impersonation changes the context login and/or user. http://msdn.microsoft.com/en-us/library/ms189492(v=sql.105).aspx
error_context | nvarchar (4000) | NOT NULL | This is user supplied value identifies the context of the error, usually a stored procedure name
error_number | int (4) | NOT NULL | This is the MSSQL defined error_number. http://msdn.microsoft.com/en-us/library/ms175069(v=sql.105).aspx
error_state | int (4) | NOT NULL | This is the MSSQL defined error_state. http://msdn.microsoft.com/en-us/library/ms180031(v=sql.105).aspx
error_message | nvarchar (8000) | NOT NULL | This is the MSSQL defined error_message. http://msdn.microsoft.com/en-us/library/ms190358(v=sql.105).aspx
error_severity | int (4) | NOT NULL | This is the MSSQL defined error_severity. http://msdn.microsoft.com/en-us/library/ms178567(v=sql.105).aspx

Primary key
Name | Columns | Description
PK_Error_Log | error_log_KEY |