During learning of FULLTEXT index, i came across one system table which gives the information of each language present in SQL Server instance. Below query you can use for the same.
SELECT dateformat, name, alias, months, days, lcid FROM MASTER.SYS.SYSLANGUAGES GO
Read previous just learned tip of fulltext index here, http://beyondrelational.com/justlearned/posts/555/adding-and-removing-stoplist-to-fulltext-index-in-sql-server.aspx
Published under: SQL Server Tips · · · ·