Support for “more” local languages sys messages – SQL Server 2012


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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s