Change Language option in SQL Server

SET LANGUAGE 'us_english'

Changed language setting to us_english.

NOTE: It applies only the current session/connection.

For verifying the settings, execute the following SQL Command

DBCC useroptions;