SQL Server Error Message :
"Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator."
What and Why "this Error":
This error occurs when a Microsoft SQL Server finds a problem with a statement issued by the current process. This could be because of many reasons like :
- File level corruption
- Statement tried to access a corrupted page
- Current statement tried to find record on missing or corrupted page/record/file/index
- Statement tried to access a corrupted table / index
The Root cause of the issue can be found by looking at specific fatal error number, which was returned initially in error message
Action Required to resolve this Error:
Action Required is 100% dependent on the fatal error number but most of the time, you need to check database consistency to confirm there is no corruption in the database by running statement
DBCC CHECKTABLE and DBCC CHECKDB
If the index is corrupted, rebuild the index
Note:
- There could be a probability that you connection is ended immediately after this error message.
- Severity level 20 indicates a problem with a statement issued by the current process.
- %d, %ld, or %D means Decimal integer value
%x means Hexadecimal number value
%ls or %.*ls means Character string value
%S_type means SQL Server -defined structure value
%c means Single character value
%lf means Double floating-point number value
Tag : "Msg 21, Level 20, State 1, Line 1",SQL Server Error Warning: Fatal error occurred at … Note the error and time, and contact your system administrator, SQL Server Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.
