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

FileNotFoundException sharepoint 2010

You may see error like Unhandled Exception: System.IO.FileNotFoundException: The Web application at http://sp2010:12523…

Nov 5, 2012

Error while accessing Manage Content and Structure in SharePoint 2010

This is a very rare but tough error you may encounter during your…

Jul 17, 2012

“There is not enough space on the disk” error while exporting SharePoint site

Today while trying to export a large sub-site using Export-SPWeb command through powershell, we got…

May 16, 2012

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