Today I was dealing with one of the questions related to local language support for SQL Server sys messages and suddenly this idea came to my mind to check whats the improvement for SQL Server 2012.
I was surprised to see that SQL Server 2012 now supports more languages for sys messages than what it was supporting earlier(2008 R2).
sys.messages catalog view will confirm the languages supported by SQL Server if you are having a localized version of SQL installed.
SELECT msg.language_id, lang.langid, alias FROM sys.messages AS msg JOIN syslanguages AS lang ON lang.msglangid = msg.language_id GROUP BY msg.language_id, lang.langid, alias
SQL Server 2008 R2
SQL Server 2012
The only important thing to notice that these localized error messages will appear only if you have installed a localized version of SQL Server(Say for an example French,Spanish or Russian)
I love to see improvements in SQL Server 2012,and these days when ever I work on something or check something new I make sure whats the behavior happening with SQL Server 2012. Apparently we all love 2012 deeply,aint we?
Thanks for reading.