Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 15:27:50 +0100

Ward,

Are you saying that this collation isn't available to select in the SETUP program? If so, do an
unattended installation and specify the collation in the ISS file. 

-- 
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ward Horsfall" <ward@nospam.threetoed.com> wrote in message
news:gZrUb.43604$Wa.13810@news-server.bigpond.net.au...
> Hi,
>
> I am wondering how do you do a custom install of SQL 2000 and set
> "SQL_Latin1_General_CP1_CI_AS " to
> be your collation order on master and tempdb. It
> seems the only way I can see to achieve such a thing
> is to do an upgrade from MSDE 2000.
>
> Thanks,
>
> Ward
>
>

Relevant Pages

  • Re: Different Collations
    ... know is to install Sql7 first and then run Sql2k over it, then I get my original collation, but I ... >> You could always rebuild your system databases. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Turkish collation makes metadata names/aliasses "case sensitive"
    ... Because the columns in the system tables will have that collation as well, ... But why and how does this affect metadata ... >> SQL Server MVP ... >>> create table TABLEI ...
    (microsoft.public.sqlserver.server)
  • Re: Table collation vs. procedure collation
    ... create proc MyProc ... declare @t table ... SQL Server MVP ... default server collation - not the collation of your DB. ...
    (microsoft.public.sqlserver.programming)
  • Re: Rebuild Master
    ... And then you should look for a collation with the number you want. ... Note that not all collations are available through SETUP / REBUILD. ... changing collation through ALTER DATABASE does not change collation for existing objects. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Change collation all db tables and db
    ... SQL Server MVP ... > collation and the collation of all the columns, ... Script contraints, stored procs, views.....; ... > I ran DTS object move but that always seems to copy the column collation. ...
    (microsoft.public.sqlserver.server)