R – Change the language of a website in Sharepoint 2007

sharepointsharepoint-2007

I have been working in my development machine with a Sharepoint installed in English. So the website I created and am woking on appears in English, I have created variations in different languages too (Spanish, Catalan, Basque, Galician).
Now I realise that the admin part that is in English, should be in Spanish.

I don't know how I could change the language, i have seen the following answer in a forum:

UPDATE dbo.Webs SET Language = 3082

This solves the problem for the language, the admin part of the website appears in Spanish, but when I enter the section of variation labels, it gives me an error.

Can anyone tell me the solution, or which other column in which table must I change (I know it is not recommended)?

Which is the table where it is saved the info about variations?

Best Answer

You should be very careful with modifying the database... not only is it not recommended but it will make your SharePoint environment unsupportable by Microsoft. Good for laughs, not much else.

So to give you the official answer, you cannot do what you are attempting without recreating the website. To quote Deploy language packs (Office SharePoint Server):

...once you choose a language-specific site template for a site or a site collection, the site or site collection will always display content in the language of the original site template.

Related Topic