FROM sys.fulltext_languages On my machine, this returns the following languages:
- British English
- Chinese (Hong Kong SAR, PRC)
- Chinese (Macau SAR)
- Chinese (Singapore)
- Simplified Chinese
- Traditional Chinese
An additional 6 languages are supported and available for a separate install. These are :
- Português (Brasil)
To install these, follow the instructions here.
The following languages are not supported for full text searching at all within SQL Server 2005:
SQL Server 2008 offers more full text language support bringing the total of available languages to 50. It would appear that Danish, Polish and Turkish remain installable additions.