Msg 2740, Level 16, State 1, Line 1
SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server.
This error message appears when you try to switch to a language that is not known by SQL Server.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. You can only switch to a language that is known and supported by SQL Server.
All versions of SQL Server.
SET LANGUAGE Inglish
In the above example the error is raised because of the typo in the language name.