How do I change the language of a FullText catalog?

Question:

---

How do I change the language of a FullText catalog in SQL server ?

Answer:

---

You must use a system stored procedure to turn a full-text catalog to a different language. There is an example below:

EXEC sp_fulltext_column InfoCategorias, Keywords, 'add', 0xC0A

Where "InfoCategorias" is the name of the table, "Keywords" is the name of the field and "0xC0A" is the code of the Spanish language.