How to change collation? 1

[TheBugSlayer]

I am trying to attach one SQL DB to another server but the Locale IDs are different as per the sp_helpsort stored procedure. One, the Windows NT 4 source shows 33282 and the other, the Win 2000 one shows 1033 (US english). When I aunch "rebuildm.exe" I can see that the two servers have the exact sort order, character set, etc. Why is it then that the Locale IDs are different and not allowing attach? How can I change the Win 2K servers locale to ID 22382?

 

[rt63]

Use the sp_configure system procedure with the parameter <Unicode locale id> something like this


EXEC sp_configure 'Unicode locale id', '22382'


You can get more details in T-SQL help/BOL




RT

 

[TheBugSlayer]

Great! I knew about sp_configure but none of the documentation I found made any mention of it. I haven't tried that yet; I will do so later on.
I have a just little concern: will changing the Locale ID using sp_configure take care or changing sort order and character set?