I tried to change default language to french by using the below query.
USE ssidps; GO EXEC sp_configure 'default language', 2 ; GO RECONFIGURE ; GO
SELECT @@language gives "us_english" always.
My aim is to change my onshore system's default language from korean to english. All error/warning messages are coming in korean when query failed. And i couldn't catch that message as i developed in English.
Its working in the current session by the query "set language french" but not for the database. I asked the same in stackexchange but i was referred to this site. https://stackoverflow.com/questions/19654101/how-to-change-default-language-of-sql-server-management-studio