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
NameTypeConstraintsDescription
error_log_KEYint (4)NOT NULLSurrogate Key, Primary Key, Clustering Key, Identity constraint. This column is maintenance for referential integrity and serves no exterial buisness constraint.
time_stampdatetime (8, 3)NOT NULLThe datetime point when the error occurred.
error_usersysname (256)NOT NULLThe database user name running the process where the error occurred. http://msdn.microsoft.com/en-us/library/ms188014(v=sql.105).aspx
error_loginsysname (256)NOT NULLThe server login running the process where the error occurred. http://msdn.microsoft.com/en-us/library/ms187934(v=sql.105).aspx
error_original_loginsysname (256)NOT NULLThe 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_contextnvarchar (4000)NOT NULLThis is user supplied value identifies the context of the error, usually a stored procedure name
error_numberint (4)NOT NULLThis is the MSSQL defined error_number. http://msdn.microsoft.com/en-us/library/ms175069(v=sql.105).aspx
error_stateint (4)NOT NULLThis is the MSSQL defined error_state. http://msdn.microsoft.com/en-us/library/ms180031(v=sql.105).aspx
error_messagenvarchar (8000)NOT NULLThis is the MSSQL defined error_message. http://msdn.microsoft.com/en-us/library/ms190358(v=sql.105).aspx
error_severityint (4)NOT NULLThis is the MSSQL defined error_severity. http://msdn.microsoft.com/en-us/library/ms178567(v=sql.105).aspx
Primary key
NameColumnsDescription
PK_Error_Logerror_log_KEY

Schema diagram