[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Collation set on sql 2005

Hi all

I'm trying to replicate a SQL server, so I need the same collation set. On source server it is SQL_Latin1_cp1_CI_AS. No matter what I do, I can't get the same collation set, the only part missing is CP1. So, it's something to do with codepage, which might be related to regional settings. So I've verified the regional settings, and they're all fine, including long and short date. In registry both are listed as 000409.

When I install SQL server, I don't get the option to select codepage1 or anything similar. When I try to use the "setup /wait..." command to reinstall and change codepage, there's no change.

Help is much appreciated.

Ole
0
orolsson
Asked:
orolsson
  • 2
1 Solution
 
RiteshShahCommented:
have you referred following link?

http://msdn.microsoft.com/en-us/library/ms179254.aspx
0
 
orolssonAuthor Commented:
Yes, that's what I referred to when I wrote "setup /wait" - although it should have been "start /wait.."

Ole
0
 
j-horbCommented:
Just been through this scenario. When installing SQL 2005, you need to select (from the 'legacy' collations) 'Dictionary order, case insensitive, for use with 1252 Character Set'.
0
 
orolssonAuthor Commented:
Perfect, that did the trick. Thanks a lot, I spent hours sifting throung MS articles and googling the web without any results.

Ole
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now