You can capture errors that occur on SQL Server with the help of the following query. You can generate alerts using any of these errors.
You can read the related articles in our site by typing Alert in the search section. You can simplify your work by placing filters in the query as below.
For example, in the following script, we want to list Alerts that are related to availability group, and English and Turkish descriptions as language.
select * from sys.messages where
(language_id=1055 or language_id=1033) AND text like '%availability%'