Query to find out all the avaliable language in SQL Server for current session

Below query will give you list of all the language.

SELECT * FROM sys.syslanguages

You can also change the language for current session using

SET LANGUAGE

For Example:

SET LANGUAGE Dutch

Enjoy..