<div>
have you referred following link?<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms179254.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms179254.aspx</a><br />

</div>


have you referred following link?

http://msdn.microsoft.com/en-us/library/ms179254.aspx [http://msdn.microsoft.com/en-us/library/ms179254.aspx]


<div>
Yes, that's what I referred to when I wrote &quot;setup /wait&quot; - although it should have been &quot;start /wait..&quot;<br />
<br />
Ole
</div>


Yes, that's what I referred to when I wrote "setup /wait" - although it should have been "start /wait.."

Ole

<div>
Perfect, that did the trick. Thanks a lot, I spent hours sifting throung MS articles and googling the web without any results.<br />
<br />
Ole
</div>


Perfect, that did the trick. Thanks a lot, I spent hours sifting throung MS articles and googling the web without any results.

Ole

<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
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. <br />
<br />
When I install SQL server, I don't get the option to select codepage1 or anything similar. When I try to use the &quot;setup /wait...&quot; command to reinstall and change codepage, there's no change.<br />
<br />
Help is much appreciated.<br />
<br />
Ole
</div>
</div>


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

Collation set on sql 2005

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.