This blog shows how to get the current language used for the session in SQL Server

Example:
SELECT @@LANGUAGE Language

The expected result would be us_english