Error Messages in SQL Server

Error messages or exceptions in SQL Server:
Error messages thrown in case of error is stored in sys.messages SQL Server table.
Below are the columns available in this table.
1. Message_id - Unique id to identify the error.
2. Language_id - Specifies the language of the message stored. (1033 indicates English)
3. Severity - Severity of the message.
4. is_event_logged - 0 indicates, the message won't get logged in the Eventviewer.
1 indicates the message will get logged in the Eventviewer.
5. Text - text displayed to the user incase of showing error.



If we want to check the content of this table,
use master
select * from sys.messages

Happy Learning!!!

Thanks and Regards,

Venkatesan Prabu .J