Changing the Language of Sites

Pre-Req: Specific Language Pack Installed. ( Korean )

SW_CD_Office_Srvr_Language_Pack_2007_64Bit_Korean_1_1_PA_BP_SvrISO_Onl_X12-34584.EXE

For changing the language of all sites in the content database to Korean the query would be:

UPDATE dbo.Webs SET Language = 1042

Changing the language of one site collection can be done with:

UPDATE dbo.Webs SET Language = 1042 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use:

UPDATE dbo.Webs SET Language = 1042 WHERE Id = [[WebId]]