Changing the language of an existing SharePoint site
Dec 26, 2008

Recently, I had a problem with an existing SharePoint site. The problem was that the site was created in English, while it should have been created in Dutch. For changing the language with existing SharePoint site, you need to fire following queries in SharePoint database as per your requirements (i.e. WebApplication, SiteCollection). For changing the language of all sites in the content database to Dutch the query would be:
UPDATE dbo.Webs SET Language = 1043
Changing the language of one site collection can be done with:
UPDATE dbo.Webs SET Language = 1043 WHERE SiteId = [[SiteCollectionId]]
And for changing the language of a single web or subsite you can use:
UPDATE dbo.Webs SET Language = 1043 WHERE Id = [[WebId]]

Leave a Reply

Your email address will not be published. Required fields are marked *


Related Posts

Designer workflow failed on start when item is added

I recently got stuck with one of the strange trouble with a developer….

Jun 16, 2010

Solve: no permissions to open this file on Excel Services

As part of an effort estimation for a MOSS project that has something…

Oct 16, 2008

Full trust proxy in SharePoint sandbox solution

You know that sandbox solution in SharePoint 2010 has certain limitation like: It…

Oct 20, 2012

Copyright © Prakash Software Solutions Pvt. Ltd. All Rights Reserved.