select * from syslanguages
The id is a Locale ID language code as defined by Microsoft. A list of them can also be found here.
adrianbanks
2009-10-11 18:49:22
+3
A:
Thanks, Adrian. Actually I had to add "sys." schema in front of syslanguages like "select * from sys.syslanguages". But thank you for pointing me the right direction. Haven't thought of prepending languages with "sys"...
Sung Meister
2009-10-11 19:19:57
Yes, the `syslanguages` view is in the `sys` schema so you can do `select * from sys.syslanguages`. My default login uses this schema, hence I didn't need the `sys.` prefix.
adrianbanks
2009-10-11 20:34:06