Bookmark and Share BitCoin Donate: 13t8gAWVpHP2ddxMp88d1NFpZjnFJC6UwK

To change the default language for the sa account in SQL Server 2005, you must run the sp_defaultlanguage stored procedure, run the DBCC FREESYSTEMCACHE command, and then start a new session. Running sp_configure to change the default language for the server does not update the default language for the sa account.

sp_helplanguage
sp_defaultlanguage 'sa', 'British'

DBCC FREESYSTEMCACHE ('ALL')