Changing collation when installing SQL2000

[polinaskulski@aol.com]

Hi,
I'm installing SQL2000 on a new cluster server.
I selected a 'custom installation' and was presented with a
'Collation settings' screen.
I need it to be SQL_Latin1_Gene ral_CP1_CI_AS collation
as I will be restoring databases with this collation.
What should I choose from the 'Collation designator' and 'SQL
Collations' box.
Is it 'Dictionary order, case-insensitive, for use with 1252
characters'?

What will be the default? Will it be the same default as for the
'typical' installation?
Thanks

[Erland Sommarskog]

Re: Changing collation when installing SQL2000

(polinaskulski@ aol.com) writes:[color=blue]
> I'm installing SQL2000 on a new cluster server.
> I selected a 'custom installation' and was presented with a
> 'Collation settings' screen.
> I need it to be SQL_Latin1_Gene ral_CP1_CI_AS collation
> as I will be restoring databases with this collation.
> What should I choose from the 'Collation designator' and 'SQL
> Collations' box.
> Is it 'Dictionary order, case-insensitive, for use with 1252
> characters'?[/color]

I would guess that is be the one, although the description also fits into
SQL_Latin1_Gene ral_CP1_CI_AI.

When you install Window collations, there are check-boxes for the
sensitivity stuff, but there might not be for SQL collations. (I
never install these.)
[color=blue]
> What will be the default? Will it be the same default as for the
> 'typical' installation?[/color]

I believe that SQL_Latin1_Gene ral_CP1_CI_AS is the default is your
regional settings is English (USA).

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp